EARLIER instead of variables
"EARLIER instead of variables" is one of the maintainability checks Auditabi runs on a Power BI semantic model. n expression(s) use EARLIER to reach an outer row context. It is a low-severity finding: hygiene and maintainability, worth fixing when you next touch the object. Capture the outer value in a VAR before the inner iteration and reference the variable.
What is detected
n expression(s) use EARLIER to reach an outer row context. Variables express the same intent and are easier to read and optimise.
Why it matters
Hygiene and maintainability. Fix when touching the object.
How to fix it
Capture the outer value in a VAR before the inner iteration and reference the variable.
Reference
Tabular Editor BPA: Use variables instead of EARLIER
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