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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors