Events
Apr 8, 3 PM - May 28, 7 AM
Sharpen your AI skills and enter the sweepstakes to win a free Certification exam
Register now!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 up, to the nearest integer or to the nearest multiple of significance.
CEILING(<number>, <significance>)
| Term | Definition |
|---|---|
number |
The number you want to round, or a reference to a column that contains numbers. |
significance |
The multiple of significance to which you want to round. For example, to round to the nearest integer, type 1. |
A number 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 return type is usually of the same type of the significant argument, with the following exceptions:
- If the number argument type is currency, the return type is currency.
- If the significance argument type is Boolean, the return type is integer.
- If the significance argument type is non-numeric, the return type is real.
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 CEILING to round prices up to the nearest unit of five cents.
= CEILING(4.42,0.05)
The following formula returns similar results as the previous example, but uses numeric values stored in the column, ProductPrice.
= CEILING([ProductPrice],0.05)
Math and Trig functions FLOOR function ISO.CEILING function ROUNDUP function