DAX Function Guide

MROUND
Empty image or helper icon

Sam McKay

CEO & Founder

How does the MROUND work?
MROUND function returns a number rounded to the desired multiple.
MROUND Formula Syntax

= MROUND(
     <number>, <multiple>
)

How do you use the MROUND?

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

Loading

Considerations when using the MROUND?

The Number and Multiple arguments must have the same sign (+/-).

Related Video Tutorials

Loading

Formula examples using the MROUND

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 Courses

Loading