Forum Discussion
Ceiling Function in Report Builder Power BI
Hi Guys!
I'm trying to use Ceiling function in one of my projects, however it doesn't do the job.
I'm I doing it wrong?
I have created new field with the values of another field and I set the function as ceiling as below:
and add it to the table as column but didn't work:
I have also set the ceiling function in the cell itself:
but still gives the same result with out the ceiling function!
Finally!
I got the solution..
with Ceiling function we need to divid by 10 then multiply by 10 if I want to round it to nearest 10ths:
=Ceiling(Fields!Sheet1_Budget2.Value / 10) * 10
4 Replies
Hi AsNa_92 ,
When applying the CEILING() function, make sure that the cell references the field correctly and that the syntax of the CEILING function is correct.
CEILING(<number>, <significance>)CEILING function (DAX) - DAX | Microsoft Learn
Verify that the data type of the field to which the CEILING function is to be applied is numeric.The CEILING function may not work properly on non-numeric data types.
This is the related document, you can view this content:
Expression examples in Power BI Report Builder - Power BI | Microsoft Learn
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous
If I added the:
<significance>
as below:
=Ceiling(Fields!Sheet1_Budget.Value,1)
I get this error:
The 'Value' expression for the field 'Sheet1_Budget2' contains an error: [BC30516] Overload resolution failed because no accessible 'Ceiling' accepts this number of arguments.
Can anyone help please ..
Finally!
I got the solution..
with Ceiling function we need to divid by 10 then multiply by 10 if I want to round it to nearest 10ths:
=Ceiling(Fields!Sheet1_Budget2.Value / 10) * 10
