Business value parsed out of a text column in DAX
"Business value parsed out of a text column in DAX" is one of the reliability checks Auditabi runs on a Power BI semantic model. n calculated column(s) extract a value from text with LEFT, MID, RIGHT or SEARCH. It is a low-severity finding: hygiene and maintainability, worth fixing when you next touch the object. Parse in Power Query or upstream, where the transformation is visible and testable, and expose a typed column.
What is detected
n calculated column(s) extract a value from text with LEFT, MID, RIGHT or SEARCH. The rule lives in the model instead of the source, and any change of format in the source silently produces wrong values.
Why it matters
Hygiene and maintainability. Fix when touching the object.
How to fix it
Parse in Power Query or upstream, where the transformation is visible and testable, and expose a typed column.
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