## How does the CEILINGfunction (DAX) work?

There are two parameters to the CEILING function (DAX): the number which is the value you want to round and the significance which is the multiple to which you want to round.

The CEILING function rounds a number up to the nearest integer or to the nearest unit of significance.

## CEILINGFormula Syntax

CEILING(
<number>, <significance>
)

## How do you use the CEILINGfunction?

There are two CEILING functions in DAX: the CEILING function which showcases the same behavior as the Excel CEILING function, and the ISO.CEILING function which follows the ISO-defined behavior when coming up with the ceiling value.

## Related Support Forum Posts

Normal Distribution Curve
DAX for a Dynamic Table instead of calculated table
SUMX not calculating correctly

## Considerations when using the CEILING function

Both DAX CEILING and ISO.CEILING functions will return the same value for positive numbers. However, they will return different values for negative numbers.

## Formula examples using the CEILINGfunction

=CEILING(4.42,0.05)

=CEILING([ProductPrice],0.05)

= CEILING(4.6,1) returns 5.
{"ft_lang_label":"__label__en","ft_lang_prob":0.72665584,"math_prob":0.9117538,"size":1177,"snap":"2022-40-2023-06","text_gpt3_token_len":267,"char_repetition_ratio":0.21994884,"word_repetition_ratio":0.0,"special_character_ratio":0.19966015,"punctuation_ratio":0.104761906,"nsfw_num_words":0,"has_unicode_error":false,"math_prob_llama3":0.99007994,"pos_list":[0],"im_url_duplicate_count":[null],"WARC_HEADER":"{\"WARC-Type\":\"response\",\"WARC-Date\":\"2022-10-02T12:04:30Z\",\"WARC-Record-ID\":\"<urn:uuid:ce77aaec-588a-4cca-8d1c-ea46a979730e>\",\"Content-Length\":\"137523\",\"Content-Type\":\"application/http; msgtype=response\",\"WARC-Warcinfo-ID\":\"<urn:uuid:2d9cf715-0467-45f7-909b-3d7db0f0f350>\",\"WARC-Concurrent-To\":\"<urn:uuid:270d285f-c126-4018-b42d-f8fb2e6b2749>\",\"WARC-IP-Address\":\"172.67.206.221\",\"WARC-Target-URI\":\"https://www.enterprisedna.co/kb/dax-function-guide/ceiling/\",\"WARC-Payload-Digest\":\"sha1:RB7FXMKMJPNIGFOGSWEWQAZZOTQ4COMN\",\"WARC-Block-Digest\":\"sha1:FZ5MWQCJGWWNEHNUHOJC2CA3KTEF3CYE\",\"WARC-Identified-Payload-Type\":\"text/html\",\"warc_filename\":\"/cc_download/warc_2022/CC-MAIN-2022-40/CC-MAIN-2022-40_segments_1664030337322.29_warc_CC-MAIN-20221002115028-20221002145028-00660.warc.gz\"}"}