Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
Calculated column
Calculated table
Measure
Visual calculation
Rounds a number down, toward zero, to the nearest multiple of significance.
Syntax
FLOOR(<number>, <significance>)
Parameters
| Term | Definition |
|---|---|
number |
The numeric value you want to round. |
significance |
The multiple to which you want to round. The argumentsnumber and significance must either both be positive, or both be negative. |
Return value
A decimal number.
Remarks
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.
-
This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.
Example
The following formula takes the values in the [Total Product Cost] column from the table, InternetSales, and rounds down to the nearest multiple of .1.
= FLOOR(InternetSales[Total Product Cost],.1)
The following table shows the expected results for some sample values:
| Values | Expected Result |
|---|---|
| 10.8423 | 10.8 |
| 8.0373 | 8 |
| 2.9733 | 2.9 |