Date table built from the facts
"Date table built from the facts" is one of the reliability checks Auditabi runs on a Power BI semantic model. n date table(s) are generated from the dates present in a fact table (CALENDARAUTO, DISTINCT or VALUES over a fact date). It is a medium-severity finding: the model still works, but results are wrong in some filter contexts, slow, or fragile under change. Generate the calendar with CALENDAR over a fixed range, or load a date dimension from the warehouse.
What is detected
n date table(s) are generated from the dates present in a fact table (CALENDARAUTO, DISTINCT or VALUES over a fact date). Days with no transaction are missing, so any period comparison silently skips them.
Why it matters
Wrong in some filter contexts, slow, or fragile under change. Fix in the next iteration.
How to fix it
Generate the calendar with CALENDAR over a fixed range, or load a date dimension from the warehouse.
Does your model fail this check?
Free static audit with the exact objects, no account, nothing stored.