Celling abd RoundUp function in power bi

[Saxon10]

Hi,

How can I use the celling and roundup function in power bi. The both functions I am applying in Excel and I am not receving any errors. 

Please refer the snapshot 

I am receving the following error"An arguments of function Roundup has the wrong type data or the result is too large or small", When I try to apply the celling and roundup in BI.

Can you please advise how can I use the both functions in Power Bi

[Anonymous · Accepted solution]

Hi @Saxon10 

I have a test by Ceiling and Rondup and they work well in power bi.

Could you share me a sample to have a test by your onedrive for business?

For reference: https://docs.microsoft.com/en-us/dax/roundup-function-dax

https://docs.microsoft.com/en-us/dax/ceiling-function-dax

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

[Saxon10]

Thanks for your reply and sorry for the late response.

I divide two columns and trying to apply celling /round up function separate column that's the reason I am receving error but if I doing celling and roundup function in same column then its working fine. Example (Celling,column 1/celling 2,1)

Thanks for your reference and help.

[VijayP]

@Saxon10  Roundup works normal in Power BI
What formula you have typed ( can you paste the syntax to see if any issue)