DAX Function Guide

ROUND
Empty image or helper icon

Sam McKay

CEO & Founder

How does the ROUND 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?

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

Loading

Considerations when using the ROUND?

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

Loading

Formula examples using the ROUND

=ROUND(2.15,1)

=ROUND(-50.55,-2)

=ROUND(626.3,-3)

Related Courses

Loading