cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Mack1int Frequent Visitor
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
Super User
Super User

Re: ABC Analysis

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,

5 REPLIES 5
stretcharm Senior Member
Senior Member

Re: ABC Analysis

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/

 

Super User
Super User

Re: ABC Analysis

Hi @Mack1int,

 

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

Mack1int Frequent Visitor
Frequent Visitor

Re: ABC Analysis

Super User
Super User

Re: ABC Analysis

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,

Mack1int Frequent Visitor
Frequent Visitor

Re: ABC Analysis

Thank You so much for all of your help!