Forum Discussion
OPS-MLTSD
Post Patron
Post PatronTransform 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 appreciated 🙂
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
