Forum Discussion
Looking Solution for COMPLEX SLICER
Well, you can number reports so that the latest one (for each shop) always has number 1. When you import files into Power Query you can put a number on each line that will tell you which report you're dealing with. If 1, it's the latest. If 2, it's the one before the latest... and so on. Then you can use this field (hidden in the UI) in your measures to return what you want. Does this not solve your problem? By the way, how do you get these numbers? Well, when you import your Excel files, PQ also gives you the dates when the files were created. From this you can easily figure out how to create the numbers.
Thnaks, numbers not the issue anymore, I gues I need help for beginner to write measure and use that for slicer?
measure should be filtering report column as per shop name. Similar way If I created table with first columnt shop name and use (Distinct count) and second column report name (show last one) - so if I write something like that as one line measure and use it for slicer?!
This is table I use on another report showing ship name (shop in my example) and showing firs and last report - works fine in this case....
Thnaks
Aleks