FLOOR Function (DAX)

How does the FLOOR function (DAX) work?

The FLOOR function (DAX) rounds a number down, toward zero, to the nearest multiple of significance.

FLOOR Formula Syntax

FLOOR(
     <number>, <significance>
)

How do you use the FLOOR function?

The FLOOR function rounds a number down to a given multiple. FLOOR works like the MROUND function, which also rounds to a given multiple, but FLOOR always rounds down.

Related Blog Posts

Related Support Forum Posts

Calculate the sum of a filtered measure
Calculate sales per square feet
Normal Distribution Curve

Considerations when using the FLOOR function

If either argument is nonnumeric, FLOOR returns **#VALUE!**error value.

If number and significance have different signs, FLOOR returns the **#NUM!**error value.

Regardless of the sign of the number, a value is rounded down when adjusted away from zero. If the number is an exact multiple of significance, no rounding occurs.

Related Video Tutorials

Formula examples using the FLOOR function

=FLOOR(InternetSales[Total Product Cost],.5)

=FLOOR(A1,”0:15″)

=FLOOR(A1,5)

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