Transform table in Power Query into long table

[OPS-MLTSD]

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 🙂

[ppm1 · Accepted solution]

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

[OPS-MLTSD]

@ppm1  thank you 🙂