Forum Discussion
Julia997
3 years agoFrequent Visitor
ABC analysis for different years
I never use DAX and I find it very complicated! I read this https://www.daxpatterns.com/abc-classification/ but I find it complicated and different from my dataset My dataset is like this https:...
amitchandak
Super User
3 years agoJulia997 , I have used the window function for a similar use case, check if that can help
Power BI Window function- Pareto Analysis, 80% of sales, Order by on Measure: https://www.youtube.com/watch?v=UVxiLc_AzSs
Power BI Window function- TOP N% with Others: https://youtu.be/rQElaRoPbUA
Julia997
3 years agoFrequent Visitor
I try to replicate but it doesn't work. The cumulated is always null.