MROUND DAX Function
The MROUND DAX Function returns a number rounded to the desired multiple, and returns a decimal number.
DAX Syntax MROUND(Number, Multiple)
The function has the following parameters:
• Number: The number to round.
• Multiple: The multiple of significance to which we want to round the number.
Note: The MROUND function rounds up, away from zero, if the remainder of dividing number by the specified multiple is greater than or equal to half the value of multiple.
Example: The following expression rounds 1.3 to the nearest multiple of .2. The expected result is 1.4.
DAX
MRound measure = MROUND(1.3,0.2)
Example: The following expression rounds 1.3 to the nearest multiple of 0.3. The expected result is 1.2.
DAX
MRound measure = MROUND(1.3,0.3)
