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
Related Course Modules
