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
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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors