Forum Discussion
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...
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
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