Ceiling Function in Report Builder Power BI

[AsNa_92]

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!

[AsNa_92 · Accepted solution]

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

[AsNa_92]

Can anyone help please .. 

[Anonymous]

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.

[AsNa_92]

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.