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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Anonymous
Not applicable

Table transpose

Hey All,

Struggeling to transpose a table.

The original table looks like below.

Employee NameDepartmentCourseDate
AD111/01/2018
AD125/04/2017
CD132/06/2019
DD211/01/2018
DD225/04/2017
DD2315/11/2016
DD242/06/2019

There are more columns, which I want to hide. Also, there are more than 4 courses, which I want to filter the redundant ones.

I want to achieve this view

Employee NameDepartmentCourse 1Course 2Course 3Course 4
AD11/01/20185/04/2017  
BD3    
CD1  2/06/2019 
DD21/01/20185/04/201715/11/20162/06/2019

 

Showing Department, and maybe other columns. Also, Showing Employees without data (empty values), like employee B above.

 

Any hint would be much appreciated.

 

Thanks!
A

1 ACCEPTED SOLUTION
MattAllington
Community Champion
Community Champion

This looks like pivoting text data to me. Read my article here. 

https://exceleratorbi.com.au/pivoting-text-data-using-power-query/



* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

HI @Anonymous 

Capture2.GIF

Use pivot column -->Course in power query 

In the  options select date

advance options  --> do not aggregate.

 

MattAllington
Community Champion
Community Champion

This looks like pivoting text data to me. Read my article here. 

https://exceleratorbi.com.au/pivoting-text-data-using-power-query/



* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
Anonymous
Not applicable

@MattAllington 

Thanks Mate.

Apparently, I was missing the do not aggregate thingi which messed up my visual.

 

Cheers!
A

 

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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