MROUND Function (DAX)
How does the MROUND function (DAX) work?
MROUND function returns a number rounded to the desired multiple.
MROUND Formula Syntax
= MROUND(
<number>, <multiple>
)
How do you use the MROUND function?
MROUND rounds up, away from zero, if by the specified multiple the remainder of the dividing number is greater than or equal to half the multiple value.
Related Blog Posts
Related Support Forum Posts
Understanding DAX Formula
Developing Complex Dax functions
Considerations when using the MROUND function
The Number and Multiple arguments must have the same sign (+/-).
Related Video Tutorials
Formula examples using the MROUND function
Example: Decimal Places
The following expression rounds 1.3 to the nearest multiple of .2. The expected result is 1.4.
= MROUND (
1.3,0.2
)
Example: Negative Numbers
The following expression rounds -10 to the nearest multiple of -3. The expected result is -9.
= MROUND (
-10,-3
)
Example: Error
The following expression returns an error, because the numbers have different signs.
= MROUND (
5,-2
)
Related DAX Functions
