Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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,
Solved! Go to Solution.
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?
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
Hi @Mack1int,
Share the link from where i can download that Excel file.
Hi @Ashish_Mathur I hope this works, https://www.dropbox.com/s/wbvip9oqqn0ugdc/ABC%20Help%20%28Latest%29.xlsx?dl=0
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,
I have a similar requirement, based on Div/Cat and Gender and YTD Sales Data i need to classify the Article Codes as ABC. The articles which contributes to the 70% of sales will be calssified as A, 70% to 90% as B, and 90% above as C. Below is the sample data.
Thanks in advance
Hi,
Please study the file which i shared the link of in my post dated 23-11-2017. Apply those formulas on your dataset as well.
The file is not accessible , it says the item might not exist/no longer available. Could you please reshare it?
Thanks
The file has been deleted somehow and i do not have the link now. Sorry for that. Share an MS Excel file with your formula/Pivot Tables based workings there. I will try to translate those formulas in the DAX language. Give adequate notes/descriptions in the Excel file so that your intention can be well understood.
Please download the excel file from above link. My requirement is Div-Cat-Gender-Site code - based on these 4 columns the YTD Sales cumulative to be calculated , and the articles which are contributing to 70% of the Cumulative sales will be categorized as A, 70-95% as B and rest all as C. I have tried in excel as per this, not sure if it is 100%. Please input your valuable feedbacks/suggestions. Thanks again
Hi,
My method is taking a lot of time to process and still not returning the correct result. Please start a new thread. I am sure others will help you.
Sure Ashish, Thanks alot for taking the effort
Thank You so much for all of your help!
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/
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
108 | |
108 | |
108 | |
90 | |
61 |
User | Count |
---|---|
171 | |
138 | |
132 | |
102 | |
86 |