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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
LogMill1
Frequent Visitor

Table Transformation

I am attempting to transform data to be tall instead of wide. Example1 below is what the data currently is and Example2 is what I would like the data to be. Any tips on how to do this within PBI? Thanks.

 

Example1:

IDDate1Date2Date3Date4Date5Date6Date7
1 1/1/2024  1/5/2024  
21/1/2024     1/8/2024
31/3/2024  1/5/2024  1/11/2024
4 1/5/2024  1/9/2024  
5  1/4/2024  1/8/2024 
61/9/2024  1/11/2024  1/14/2024
7 1/10/2024  1/15/2024  

 

 

Example2:

IDDate #Date
1Date21/1/2024
1Date51/5/2024
2Date11/1/2024
2Date71/8/2024
3Date11/3/2024
3Date41/5/2024
3Date71/11/2024
4Date21/5/2024
4Date51/9/2024
5Date31/4/2024
5Date61/8/2024
6Date11/9/2024
6Date41/11/2024
6Date71/14/2024
7Date21/10/2024
7Date51/15/2024
1 ACCEPTED SOLUTION
gadielsolis
Super User
Super User

Hello,

 

You can achieve this in Power Query by selecting column Id an clicking on unpivot other columns, then you can filter the blanks on the column date.

View solution in original post

1 REPLY 1
gadielsolis
Super User
Super User

Hello,

 

You can achieve this in Power Query by selecting column Id an clicking on unpivot other columns, then you can filter the blanks on the column date.

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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