Forum Discussion
Abc analysis
- ajin8 years ago
Helper II
Hi ChrisMendoza ,
Thanks for responding to my query. I had reviewed this blog earlier but couldnt fully understand it as i'm new to dax. Plus isn't it used in excel?
Thanks
Aj
- ChrisMendoza8 years ago
Resident Rockstar
The output is Power Pivot if I recall which is an addon to Excel however, it uses DAX so the pattern could be applied to BI. You'll note that Greg_Deckler actually has looked at the same document and found a potential limitation or an improvement, however you look at it, it's pretty nifty. To be honest I have yet to have a project with an ABC need so I've never looked into implementation I just knew of ABC.
Good luck in your search.
- Greg_Deckler8 years ago
Community Champion
ajin- If you download the PBIX attached to that Quick Measure, it has a full implementation of that DAX pattern as well as my own implementation of that pattern as a measure. Attaching it here as well. The issue is that the actual DAX is going to depend on your actual data and your actual tables. I used AdentureWorks 2014 as the basis for mine. In order to be that specific, you will need to include example/sample data as text that can be copied and pasted.
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
- ajin8 years ago
Helper II
Greg_Deckler Will definetly look into the pbi. Further will try to load a sample of my data or a pbix file to give you a clearer understanding. Thanks again for the timely reply.
Thanks
Aj