ROUND DAX Function
The ROUND DAX function rounds a number to the specified number of digits, and returns it.
DAX Syntax ROUND(Number, NumberOfDigits)
The function has the following parameters:
- Number: The number we want to round.
- NumberOfDigits: The number of digits to which we want to round. A negative value rounds digits to the left of the decimal point; a value of zero rounds to the nearest integer.
Example 1: The following formula rounds 11.576 up, to two decimal places. The expected result is 11.58.
DAX
Round measure = ROUND(11.576,2)
Example 2: The following formula rounds 11.576 to one decimal place to the left of the decimal point. The expected result is 10.
DAX
Round measure = ROUND(11.576,-1)
