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
Center of Excellence

DOWNLOAD


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


Download DAX Formulas Reference Guide
Download DAX Formula Reference Guide
Membership