Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
117
Views
Topic starter
How can I get from this row data, to the following report using Power Query ?
- Raw Data
Title |
Categories |
Due Date |
Finalizing R&R definition |
Fundamental |
Jan-21 |
Finalizing the effective BI |
Fundamental |
Jan-21 |
Reevaluating the Mo framework |
Fundamental |
Jan-21 |
Tools MVP2 |
Tools |
Aug-21 |
Readout |
Communication |
Jan-21 |
Townhall |
Communication |
Jan-21 |
- After Power Query
| Categories | Jun-21 | Aug-21 |
| Fundamental | Finalizing R&R definition Finalizing the effective BID Reevaluating the Mo framework |
|
| Tools | Tools MVP2 | |
| Communication | Readout Townhall |
Posted : 01/06/2021 4:16 pm
Hello Hamid,
Welcom to MOTH.
In my view you don't need to involve Power Query to get what you want, but Power Pivot.
I have created an example file showing how it can be. Feel free to add more data to the table and then refresh the Pivot Table to see the changes.
Br,
Anders
Posted : 02/06/2021 11:24 am
