ModelReliabilityLow
Money stored as a floating-point number
"Money stored as a floating-point number" is one of the reliability checks Auditabi runs on a Power BI semantic model. n monetary column(s) use the double type. It is a low-severity finding: hygiene and maintainability, worth fixing when you next touch the object. Use the fixed decimal (currency) type for money.
What is detected
n monetary column(s) use the double type. Floating point cannot represent every decimal exactly, so totals drift by cents and two identical-looking amounts fail an equality test.
Why it matters
Hygiene and maintainability. Fix when touching the object.
How to fix it
Use the fixed decimal (currency) type for money.
Reference
Microsoft: data types in Power BI Desktop
Does your model fail this check?
Free static audit with the exact objects, no account, nothing stored.