Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 link -
https://1drv.ms/x/s!Arm2JbpOh1VdgSU-gkfBnsXNKehF?e=tqzfSH
I was able to create one by one buckets but thats not going to help what I'm trying to achieve.
Please see if you can be help on this.
Dii
Solved! Go to Solution.
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.
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 Abbas.
Is it possible to capture the last three months for each ID ( The month list can be dynamic) :
Right now I have a static conditional column [ Month Key] but that's not true always.
https://1drv.ms/u/s!Arm2JbpOh1VdgScd8jJYOhMl1j8V?e=SBMRpi
then want to change the below DAX formula to capture the last 3-month only
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
Thanks Tom.
Here is the sample Data link - I removed the salary column to make it easier.
https://1drv.ms/x/s!Arm2JbpOh1VdgSU-gkfBnsXNKehF?e=tqzfSH
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
104 | |
77 | |
68 | |
61 |
User | Count |
---|---|
148 | |
107 | |
107 | |
83 | |
70 |