Exchange rate written into the DAX
"Exchange rate written into the DAX" is one of the reliability checks Auditabi runs on a Power BI semantic model. n measure(s) multiply or divide by a literal rate next to a currency word. It is a medium-severity finding: the model still works, but results are wrong in some filter contexts, slow, or fragile under change. Join a rate table on the date and the currency, and convert with the rate that applies to each row.
What is detected
n measure(s) multiply or divide by a literal rate next to a currency word. The rate is frozen at the day it was typed, and every figure derived from it drifts from reality.
Why it matters
Wrong in some filter contexts, slow, or fragile under change. Fix in the next iteration.
How to fix it
Join a rate table on the date and the currency, and convert with the rate that applies to each row.
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