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.
Good evening all,
I'm trying to get percentage difference between two columns and I'm having some issues with it
my table is, (FYI the table code have duplicated skus)
Item On Hand Bal safety stock
PRI202W 100 50
ABS123 50 100
appreciate any help with this,
Regards
Snowy
Solved! Go to Solution.
Hi,
Try this measure
=SUM([On Hand Bal])/((SUM([On Hand Bal])+SUM([safety stock]))/2)
This might be helpful also to anyone looking for this. I used variables (following along with the math provided by the same website the above poster referenced). Everything matched up.
This very much depends on what you want to show. But generally speaking you would make a measure dividing the sum of one with the sum of the other.
Measure = DIVIDE(SUM([On Hand Bal]) , SUM([safety stock]) , BLANK())
Good day Tax628
The issue with this is it still is wrong,
As the first line % dif between 134 and 200 is 39.52%, not 67% I'm not sure where that 67% is getting pulled from.
Hi,
How did you calculate 39.52% The numerator is 66. What is the denominator?
As per below
So I have used a pie chart and it worked fine but when done in a table as per below its showing 67%, I wanna get away from using the BOM filter on the side as I got more than one visual on the screen. Thx for your help.
Hi,
Try this measure
=SUM([On Hand Bal])/((SUM([On Hand Bal])+SUM([safety stock]))/2)
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |