ROUND Function (DAX)

How does the ROUND function (DAX) work?

The ROUND function (DAX) rounds a number to the specified number of digits.

ROUND Formula Syntax

ROUND(
     <number>, <num_digits>
)

How do you use the ROUND function?

The ROUND function is used to return a number rounded to a given number of digits. The ROUND function can round to the right or left of the decimal point.

Related Blog Posts

Related Support Forum Posts

Decimal places – Rounding
Power Query – Round Up Date
Rounding values in Dax vs. Excel

Considerations when using the ROUND function

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 Video Tutorials

Formula examples using the ROUND function

=ROUND(2.15,1)

=ROUND(-50.55,-2)

=ROUND(626.3,-3)

Related DAX Functions

ROUND
INT
MROUND
ROUNDDOWN

Related Course Modules

Ultimate-Beginners-Guide-To-PowerBI

DOWNLOAD


Download our comprehensive DAX Formula Reference Guide as perfect companion as you learn how to use DAX formulas within Power BI.


Download DAX Formula Reference Guide