Forum

Power Query on 3 Co...
 
Notifications
Clear all

Power Query on 3 Column

2 Posts
2 Users
0 Reactions
117 Views
(@hamidzahrani)
Posts: 1
New Member
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
Anders Sehlstedt
(@sehlsan)
Posts: 972
Prominent Member
 

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
Share: