ISO.CEILING is a DAX function that rounds a number up to the nearest integer or multiple of a specified significance.
ISO.CEILING(
Number,
Significance
)| Argument | Properties | Description |
|---|---|---|
| Number | The value you want to round. | |
| Significance | Optional | The multiple to which you want to round. |
A number, of the same type as the number argument, rounded as specified.
There are two CEILING functions in DAX, with the following differences:
The CEILING function emulates the behavior of the CEILING function in Excel.
The ISO.CEILING function follows the ISO-defined behavior for determining the ceiling value.
The two functions return the same value for positive numbers, but different values for negative numbers. When using a positive multiple of significance, both CEILING and ISO.CEILING round negative numbers upward (toward positive infinity). When using a negative multiple of significance, CEILING rounds negative numbers downward (toward negative infinity), while ISO.CEILING rounds negative numbers upward (toward positive infinity).
The result type is usually the same type of the significance used as argument with the following exceptions:
If the first argument is of currency type then the result will be currency type.
If the optional argument is not included the result is of integer type.
If the significance argument is of Boolean type then the result is of integer type.
If the significance argument is non-numeric type then the result is of real type.
The following formula returns 4.45. This might be useful if you want to avoid using smaller units in your pricing. If an existing product is priced at $4.42, you can use ISO.CEILING to round prices up to the nearest unit of five cents.
= ISO.CEILING(4.42,0.05)
The following formula returns the ISO ceiling value of -4.40.
= ISO.CEILING(-4.42,0.05)
Other functions related to ISO.CEILING are:
2023-2024 © BI Gorilla. All rights are reserved. Information from Microsoft docs is property of Microsoft Corp. | Privacy Policy