Forum Discussion

AsNa_92's avatar
AsNa_92
Resolver II
2 years ago
Solved

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 th...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • AsNa_92's avatar
    AsNa_92
    2 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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's avatar
AsNa_92
Resolver II
2 years ago

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.