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...
  • AsNa_92's avatar
    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