Forum Discussion
Post ProdigyCelling abd RoundUp function in power bi
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
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.
3 Replies
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.
Saxon10Thanks 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.
