Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi Community Members,
I am trying to roundoff SALES column to the nearest 100 before decimal point. ROUND function is rounding SALES to the nearest 100 before the decimal point but as soon as I change SALES column to SUM of SALES, the ROUND function does not work as expected.
First column is SALES and second is round off of SALES - this is working as expected but the next images is SUM of SALES (not working as expected)
First column is SALES and second column is SUM of SALES. The second column is not coming-up correctly.
Can someone please share thoughts on this issue?
Solved! Go to Solution.
Hi @PS0304
Sorry for misunderstanding.
You can use :
I also updated PBIX which I linked in the first response.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi @PS0304
You can use measure :
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi @Ritaf1983
Thanks for responding and trying. Much appreciated.
I tried but it's rounding slightly off. Image on the left side is the actual SUM of SALES and the right image is after using the FLOOR function. The function should return 25,267,300 because 57 should be rounded off to the next hundred. Could you please provide more insight here.
Hi @PS0304
Sorry for misunderstanding.
You can use :
I also updated PBIX which I linked in the first response.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
@PS0304
You're welcome 🙂
User | Count |
---|---|
120 | |
72 | |
69 | |
57 | |
50 |
User | Count |
---|---|
167 | |
82 | |
68 | |
65 | |
53 |