DAX function
ROUND — DAX function reference
Round to N decimals.
Syntax
dax
ROUND(<number>, <num_digits>)
Examples
dax
ROUND([Sales], 2)
→ A number
dax
ROUND([Total Sales], -3)
→ Rounds to the nearest thousand, using a negative num_digits
dax
SUMX(Sales, ROUND(Sales[Amount] * Sales[TaxRate], 2))
→ Rounds tax per line before summing, to match how the source system rounds
Common mistakes & gotchas
- ROUND uses "round half away from zero," not banker’s rounding — 2.5 rounds to 3, -2.5 rounds to -3, which can differ from a financial system using round-half-to-even.
- Rounding inside an iterator’s per-row expression (round-then-sum) can produce a different total than rounding the final aggregated sum — decide deliberately which one matches the source system you’re reconciling against.
Related DAX functions
From Math & statistics