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

DOWNLOAD

To access our comprehensive DAX formula reference guide just insert your email address below. The resource will download immediately and we’ll also email it to you.