Forum Discussion
ABC Analysis
Good Evening Everyone!
I have been working over the last few weeks on creating an ABC analysis however, I am still struggling with the calculations and formulas necessary to meet the requirements of the analysis I need to get done. This is somewhat due to being unable to find tutorials that can do an ABC analysis on so many levels and still be relatively new to DAX & PowerBI.
I have attached an image below to show what I need to achieve. Any help would be much appreciated.
Many Thanks,
Hi,
See if my solution in this file helps. I think some of your answers in the ABC column are wrong. Please check my ABC column,
15 Replies
The SQLBI boys have pages about ABC Analysis on their daxpatterns site
They wrote the pages based on Excel and Powerpivot, but PowerBI uses the same model
http://www.daxpatterns.com/abc-classification/
http://www.daxpatterns.com/abc-classification-dynamic/
Hi,
See if my solution in this file helps. I think some of your answers in the ABC column are wrong. Please check my ABC column,
Hi Ashish,
Is there a quick way to get following results using RANKX in ABC analysis?
- Top 10% of annual cost to A
- Between 10% and 50% of annual cost to B
- Between 50% and 90% of annual cost to C
- Bottom 10% of annual cost to D
Looking forward for your kind response.
Thanks & best regards,
PG
Hi,
Your question is not clear. Share some data, describe the question and show the expected result.
Hi Ashish,
Thank you very much for your quick reponse and sorry for the delays from my side.
I have figured another way to define ABC which is working fine.
Thanks again. Have a wonderful day.
Best regards,
PG
