TODAY() used as a filter boundary
"TODAY() used as a filter boundary" is one of the reliability checks Auditabi runs on a Power BI semantic model. n measure(s) filter a date column against TODAY() or NOW(). It is a low-severity finding: hygiene and maintainability, worth fixing when you next touch the object. Flag the current period in the date table (IsCurrentMonth, IsToday) and filter on the flag, so the boundary is computed once at refresh.
What is detected
n measure(s) filter a date column against TODAY() or NOW(). The value changes while the report is cached, so two users can see different numbers for the same selection.
Why it matters
Hygiene and maintainability. Fix when touching the object.
How to fix it
Flag the current period in the date table (IsCurrentMonth, IsToday) and filter on the flag, so the boundary is computed once at refresh.
Does your model fail this check?
Free static audit with the exact objects, no account, nothing stored.
More DAX checks
- Arithmetic or comparison on a measure that returns text
- Measure returning text in one branch and a number in another
- Share denominator clears a fact-table column instead of the dimension
- "Previous period" window overlaps the current one
- Percentage label built without ×100
- Percentages and amounts summed together