TODAY()/NOW() assumptions in measures
"TODAY()/NOW() assumptions in measures" is one of the reliability checks Auditabi runs on a Power BI semantic model. A measure calls TODAY() or NOW(). It is a low-severity finding: hygiene and maintainability, worth fixing when you next touch the object. Compute the current date once in the date table (an IsToday / IsCurrentMonth flag) or expose it as a measure in a dedicated table so the assumption is explicit.
What is detected
A measure calls TODAY() or NOW(). The result depends on when the query runs, cannot be reproduced for a past report, and breaks caching.
Why it matters
Hygiene and maintainability. Fix when touching the object.
How to fix it
Compute the current date once in the date table (an IsToday / IsCurrentMonth flag) or expose it as a measure in a dedicated table so the assumption is explicit.
Does your model fail this check?
Free static audit with the exact objects, no account, nothing stored.