Forum Discussion
Solved
Transform table in Power Query into long table
hello, I have a table that looks like this: and I want the table to look like this: How can i effectively achieve this in Power Query in Power BI? Your help is mucha appreciate...
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
