DAX Function Guide
FLOOR
Sam McKay
CEO & Founder
How does the FLOOR work?
FLOOR Formula Syntax
FLOOR(
<number>, <significance>
)
How do you use the FLOOR?
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
Loading
Considerations when using the FLOOR?
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
Loading
Formula examples using the FLOOR
=FLOOR(InternetSales[Total Product Cost],.5)
=FLOOR(A1,”0:15″)
=FLOOR(A1,”0:15″)
Related Courses
Loading