ROUND - Daxplained

ROUND is a DAX function that rounds a number to a specified number of digits.

Syntax

ROUND(
   Number,
   NumberOfDigits
)

Argument	Properties	Description
Number		The number you want to round.
NumberOfDigits		The number of digits to which you want to round. Negative rounds to the left of the decimal point; zero to the nearest integer.

A decimal number.

If num_digits is greater than 0 (zero), then number is rounded to the specified number of decimal places.
If num_digits is 0, the number is rounded to the nearest integer.
If num_digits is less than 0, the number is rounded to the left of the decimal point.
Related functions
- To always round up (away from zero), use the ROUNDUP function.
- To always round down (toward zero), use the ROUNDDOWN function.
- To round a number to a specific multiple (for example, to round to the nearest multiple of 0.5), use the MROUND function.
- Use the functions TRUNC and INT to obtain the integer portion of the number.

The following formula rounds 2.15 up, to one decimal place. The expected result is 2.2.

= ROUND(2.15,1)

The following formula rounds 21.5 to one decimal place to the left of the decimal point. The expected result is 20.

= ROUND(21.5,-1)

Other functions related to ROUND are:

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/dax/round-function-dax