Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anya_T
Frequent Visitor

Row to Column

Hi,

 

I have huge daily incoming data in this format

ManagerUser IdColumn2021-19
anukshagbrabhisActual TIM Time (hrs)47.99
anukshagbrabhisActual overlap TIM Time (hrs)47.83
anukshagbrabhisTime Diff %0.33%
anukshagbtejashwActual TIM Time (hrs)21.41
anukshagbtejashwActual overlap TIM Time (hrs)20.52
anukshagbtejashwTime Diff %4.18%
anukshagchinthumActual TIM Time (hrs)46.8
anukshagchinthumActual overlap TIM Time (hrs)46.2
anukshagchinthumTime Diff %1.28%
anukshaghemagActual TIM Time (hrs)3.43
anukshaghemagActual overlap TIM Time (hrs)3.37
anukshaghemagTime Diff %1.65%

 

But i want to have this table like this

ManagerUser IdActual TIM Time (hrs)Actual overlap TIM Time (hrs)Time Diff %
anukshagbrabhis47.9947.830.33%
anukshagbtejashw21.4120.524.18%
anukshagchinthum46.846.21.28%
anukshaghemag3.433.371.65%

 

What are the different ways to do this?

 

 

1 ACCEPTED SOLUTION
ryan_mayu
Super User
Super User

@Anya_T 

i think you can use pivot in the PQ

1.PNG2.PNG

= Table.Pivot(#"Changed Type", List.Distinct(#"Changed Type"[Column]), "Column", "2021-19")




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

2 REPLIES 2
ryan_mayu
Super User
Super User

@Anya_T 

i think you can use pivot in the PQ

1.PNG2.PNG

= Table.Pivot(#"Changed Type", List.Distinct(#"Changed Type"[Column]), "Column", "2021-19")




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




daxer-almighty
Solution Sage
Solution Sage

Using the Pivot operation in Power Query. (EDIT: Sorry, I first mistakenly wrote Unpivot.)

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.