Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I'm trying to round to the nearest $5.
HPayRoundUp = ROUNDUP([HPay],-0.5)
It takes 22.45 and is rounding to 30.
If I go any lower (-0.2) it goes to 23
Solved! Go to Solution.
Hi @kattlees,
Then you can a formula like this :
HPayRoundUp = (INT([HPay]/5)+1)*5
and if you have negative number then you will adapt it...
Ninter
Hi @kattlees,
Did you try the Mround function?
Let us know if you tried and did not work, then give few examples with expected results and we will figure out.
Thank you.
Ninter
Yes, HPayRoundUp = MROUND([HPay],5) rounds down so 22.45 becomes 20
Hi @kattlees,
So for example 22.45 you want 30, and what about 16.45, 18.56 or 27.64?
Thank you.
Ninter
Not quite. I want 22.45 to go to 25.. 22.01 would go to 25
Everything would round UP to the next $5 increment.
16.45 would go to 20, 27.64 would go to 30.
Hi @kattlees,
Then you can a formula like this :
HPayRoundUp = (INT([HPay]/5)+1)*5
and if you have negative number then you will adapt it...
Ninter
Thank you!!!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
84 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |