Amount or quantity stored as text
"Amount or quantity stored as text" is one of the modeling checks Auditabi runs on a Power BI semantic model. n column(s) whose name says amount, quantity, price or rate are typed as text. It is a medium-severity finding: the model still works, but results are wrong in some filter contexts, slow, or fragile under change. Set the type in Power Query as close to the source as possible.
What is detected
n column(s) whose name says amount, quantity, price or rate are typed as text. They cannot be aggregated, they sort alphabetically, and any implicit conversion in DAX is a runtime error waiting to happen.
Why it matters
Wrong in some filter contexts, slow, or fragile under change. Fix in the next iteration.
How to fix it
Set the type in Power Query as close to the source as possible.
Does your model fail this check?
Free static audit with the exact objects, no account, nothing stored.