FORMAT used in a calculated column
"FORMAT used in a calculated column" is one of the performance checks Auditabi runs on a Power BI semantic model. n calculated column(s) call FORMAT. It is a low-severity finding: hygiene and maintainability, worth fixing when you next touch the object. Keep the native type and set the format string on the column, or compute the label in a measure.
What is detected
n calculated column(s) call FORMAT. The result is text stored for every row: it sorts alphabetically, cannot be aggregated and costs dictionary space.
Why it matters
Hygiene and maintainability. Fix when touching the object.
How to fix it
Keep the native type and set the format string on the column, or compute the label in a measure.
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