Forum Discussion

ajin's avatar
ajin
Icon for Helper II rankHelper II
8 years ago

Abc analysis

Hi Guys,    Has anyone done an abc anlysis in powerbi itself and not excel, such as the one shown below(probably excel), If so could you'll share the pbix file or the dax codes (need dax for runnin...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
8 years ago

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

ajin's avatar
ajin
Icon for Helper II rankHelper II
8 years ago

Hi Greg_Deckler  I've attached my pbix file which i am using i need to get an abc analysis for revenue ( XXPBI_sales_v  table ) and qty invoiced (XXPBI_sales_v table). For dates i am using GL date ( XXPBI_GL_periods_V table)ABC analysis

 

 

Thanks 

Aj 

  • charleshale's avatar
    charleshale
    Icon for Continued Contributor rankContinued Contributor
    6 years ago

    Did you ever solve this one and if so would you link to the file?   I am trying to do an ABC analysis on a simple measure

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Icon for Super User rankSuper User
      6 years ago

      Hi,

      Share your PBI file and show the expected result.