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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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