Forum Discussion
Solved
Newbies question - Multiple buckets
Hi all, I'm trying to create buckets - but found difficult how to only get the last 3- month by ID. Basically wil only select the last 3- months to creat the buckets. Here is the sample Data lin...
Here is the URL to my solution - Aknas multiple buckets solutions.pbix
I hope it helps. Please accept it as a solution if it helps you achieve your desired output.
For creating buckets I have added a conditional column, you can find it in the power query applied steps.
For filtering the dates, I have used TOP N on each of the corresponding IDs.
Thanks Abas.