ROUND, ROUNDUP, ROUNDDOWN, MROUND – rounding functions (DAX – Power Pivot, Power BI)
So which functions can we used in DAX?
Basic rounding function. Its syntax is very simple – what is rounded and how many decimals do we need. For rounding “to the left” from decimal point we use negative numbers.
To round 123,456 to hundredths, lets write:
which results in:
To round the same number to tens, write:
and the result is:
These work similarly, just round up or down.
MROUND works similarly to older versions FLOOR and CEILING – instead of number of digits we use multiples. So for hundredths use 0,01 or for tens use 10. You can also round to, lets say fives or fifties (5, 50)…