FLOOR is a DAX function that rounds a number down to the nearest multiple of a specified significance.
FLOOR(
Number,
Significance
)| Argument | Properties | Description |
|---|---|---|
| Number | The number you want to round. | |
| Significance | The multiple to which you want to round. Number and significance must either both be positive or both be negative. |
A decimal number.
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.
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 |
Other functions related to FLOOR are:
2023-2024 © BI Gorilla. All rights are reserved. Information from Microsoft docs is property of Microsoft Corp. | Privacy Policy