Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register 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/
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
92 | |
82 | |
71 | |
49 |
User | Count |
---|---|
143 | |
121 | |
111 | |
59 | |
57 |