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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
OPS-MLTSD
Post Patron
Post Patron

Transform table in Power Query into long table

hello,

 

I have a table that looks like this:

OPSMLTSD_0-1685732270944.png

 and I want the table to look like this:

OPSMLTSD_1-1685732490467.png

How can i effectively achieve this in Power Query in Power BI?

 

Your help is mucha appreciated 🙂

1 ACCEPTED SOLUTION
ppm1
Solution Sage
Solution Sage

In the query editor, select your first 3 columns (ctrl-click), right click and choose "unpivot other columns". Then you can change the column with dates to type date.

 

Pat

 

Microsoft Employee

View solution in original post

2 REPLIES 2
ppm1
Solution Sage
Solution Sage

In the query editor, select your first 3 columns (ctrl-click), right click and choose "unpivot other columns". Then you can change the column with dates to type date.

 

Pat

 

Microsoft Employee

@ppm1  thank you 🙂

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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