Forum Discussion
Aggregate data Power Query Editor
Hello Community,
I didn't find the appropriate way to solve my problem.
I want to aggregate my data by the fisrt column (see the screenshot below)
Expecting result is :
| column1 | column2 | column3 | column4 | ... | ... |
| 4328 | 31/08/2018 | 25/03/2019 | 25/09/2019 | .... | ... |
Thank you in advance !!
hhaimer what you should do it, first unpivot the data, it will remove null rows and then pivot it back.
✨ Follow us on LinkedIn and to our YouTube channel
Learn about conditional formatting at Microsoft Reactor
My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.
3 Replies
hhaimer what you should do it, first unpivot the data, it will remove null rows and then pivot it back.
✨ Follow us on LinkedIn and to our YouTube channel
Learn about conditional formatting at Microsoft Reactor
My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.
Thank you !! it's work
Hi hhaimer ,
You can click on the column in your data in Power Query Editor, and follow the steps in the order shown below:
Then once you are in the GROUP BY window, choose Advanced option, in case you want to add more aggregations after choosing the column for Grouping. Something like below:
Thanks,
Pragati
