Date arithmetic instead of DATEADD
"Date arithmetic instead of DATEADD" is one of the dax quality checks Auditabi runs on a Power BI semantic model. n expression(s) shift a period by adding or subtracting days from a date column instead of using DATEADD or PARALLELPERIOD. It is a low-severity finding: hygiene and maintainability, worth fixing when you next touch the object. Use DATEADD with the right interval, or DATESINPERIOD anchored on the date table.
What is detected
n expression(s) shift a period by adding or subtracting days from a date column instead of using DATEADD or PARALLELPERIOD. Arithmetic ignores month lengths, leap years and fiscal calendars.
Why it matters
Hygiene and maintainability. Fix when touching the object.
How to fix it
Use DATEADD with the right interval, or DATESINPERIOD anchored on the date table.
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