Year-to-date on a model that looks fiscal
"Year-to-date on a model that looks fiscal" is one of the reliability checks Auditabi runs on a Power BI semantic model. n measure(s) use TOTALYTD or DATESYTD without a year-end date, while the model carries fiscal columns. It is a low-severity finding: hygiene and maintainability, worth fixing when you next touch the object. Pass the fiscal year-end as the last argument, for example TOTALYTD([Sales], 'Date'[Date], "30/06").
What is detected
n measure(s) use TOTALYTD or DATESYTD without a year-end date, while the model carries fiscal columns. The measure then closes the year in December and contradicts the fiscal columns next to it.
Why it matters
Hygiene and maintainability. Fix when touching the object.
How to fix it
Pass the fiscal year-end as the last argument, for example TOTALYTD([Sales], 'Date'[Date], "30/06").
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