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

ROUND
ROUNDUP
INT

Related Course Modules

Ultimate-Beginners-Guide-To-PowerBI

DOWNLOAD

To access our comprehensive DAX formula reference guide just insert your email address below. The resource will download immediately and we’ll also email it to you.