MROUND DAX Function (Math and Trig)
Returns a number rounded to the desired multiple.
Syntax
MROUND ( <Number>, <Multiple> )
| Parameter | Attributes | Description |
|---|---|---|
| Number |
The value to round. |
|
| Multiple |
The multiple to which you want to round the number. |
Return values
Scalar A single decimal value.
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
2018-2023 © SQLBI. All rights are reserved. Information coming from Microsoft documentation is property of Microsoft Corp. » Contact us » Privacy Policy & Cookies