MROUND DAX Function (Math and Trig)
Returns a number rounded to the desired multiple.
Syntax
Parameter | Attributes | Description |
---|---|---|
Number |
The value to round. |
|
Multiple |
The multiple to which you want to round the number. |
Return values
Rounded number.
Remarks
MROUND 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.
The Number and Multiple arguments must have the same sign (+/-).
Examples
Use MROUND ( number, SIGN ( number ) * multiple ) if the the sign of the number is not known in advance:
DifferenceYOY RoundedToThousands := VAR Difference = [DifferenceYOY] VAR Multiple = 1000 RETURN MROUND ( Difference, SIGN ( Difference ) * multiple )
-- Rounding functions, using multiples of the second argument -- -- FLOOR returns the smaller multiple -- MROUND returns the nearer multiple (does not work with negative values) -- CEILING returns the larger multiple -- ISO.CEILING is like CEILING, handles differently negative numbers DEFINE VAR Vals = GENERATESERIES ( 5, 20, 2 ) EVALUATE ADDCOLUMNS ( Vals, "FLOOR", FLOOR ( [Value], 3 ), "MROUND", MROUND ( [Value], 3 ), "CEILING", CEILING ( [Value], 3 ), "ISO.CEILING", ISO.CEILING ( [Value], 3 ) )
Value | FLOOR | MROUND | CEILING | ISO.CEILING |
---|---|---|---|---|
5 | 3 | 6 | 6 | 6 |
7 | 6 | 6 | 9 | 9 |
9 | 9 | 9 | 9 | 9 |
11 | 9 | 12 | 12 | 12 |
13 | 12 | 12 | 15 | 15 |
15 | 15 | 15 | 15 | 15 |
17 | 15 | 18 | 18 | 18 |
19 | 18 | 18 | 21 | 21 |
Related functions
Other related functions are:
Last update: Sep 14, 2023 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo, Jes Hansen
Microsoft documentation: https://docs.microsoft.com/en-us/dax/mround-function-dax