Forum Discussion

Aknas's avatar
Aknas
Frequent Visitor
3 years ago
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...
Need Help
  • AbbasG's avatar
    AbbasG
    3 years ago

    Aknas

    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.

     

     

TomMartens's avatar
TomMartens
Super User
3 years ago

Hey Aknas ,

 

provide sample data that can easily be copied to pbix file, describe the expected result based on the sample data you provide.

 

Regards,

Tom