cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

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,

 

Screen Shot 2017-11-22 at 20.02.05.png

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

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,


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

8 REPLIES 8
Highlighted
Memorable Member
Memorable Member

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/

 

Highlighted
Super User III
Super User III

Hi @Mack1int,

 

Share the link from where i can download that Excel file.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Highlighted
Highlighted

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,


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

Highlighted

Thank You so much for all of your help! 

Highlighted
Helper II
Helper II

@Ashish_Mathur 

 

Hi Ashish,

 

Is there a quick way to get following results using RANKX in ABC analysis?

 

    1. Top 10% of annual cost to A
    2. Between 10% and 50% of annual cost to B
    3. Between 50% and 90% of annual cost to C
    4. Bottom 10% of annual cost to D

Looking forward for your kind response.

 

Thanks & best regards,

 

PG

Highlighted

Hi,

Your question is not clear.  Share some data, describe the question and show the expected result.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Highlighted

@Ashish_Mathur 

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

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors