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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

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
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

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