Dynamic ABC Classification
Greg_Deckler Hi Greg, Did you manage to achieve the above-mentioned ABC technique by using Date slicer and second measure for sameperiodlastyear?
For example,
The ABCclass of "Product 123" in Year 2021/Quarter 1 was A
The ABCclass of "Product 123" in Year 2020/Quarter 1 (SAME PERIOD LAST YEAR) was B
and then both measures to be used simultaneously in a Table?
Anonymous Not sure I entirely understand. There is a much improved version of this measure in my book, DAX Cookbook and you can find the chapter PBIX files on GitHub. First recipe in Chapter 12. And it would be unlike me to use SAMEPERIODLASTYEAR because I hate those functions. https://community.powerbi.com/t5/Community-Blog/To-bleep-With-Time-Intelligence/ba-p/1260000
Greg_Deckler thank you for your time and for the answer. I recognize my mistake that I had to initially provide more information about the desired effect, but anyway, here's what I want to achieve as a result:
I am trying to achieve а dynamic (responsive to date and other features) ABC customer classification together with time comparison indicators, namely, classification of customers based on the currently selected period but also I want to show in the second column of the table what was the class during the same period last year. I used the term SAMEPERIODLASTYEAR (not the function) only to represent the result I was looking for, without thinking that this was the right approach.
If I have to be more detailed, I want to achieve something like a combination of your dynamic approach (which is much faster than that of SQLBI guys) and the snapshot approach of SQLBI, described here: https://www.daxpatterns.com/abc-classification/
I looked at your example in github and I think that you really improved it a lot, but I can't figure out how to make it dynamic for more than 1 period.
Something like this:
Regards,
Georgi