Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Dear all,
I hope you can help me with my current problem. I have date in the following format:
Date | 30.06.2021 | 31.07.2021 | 31.08.2021 |
ValueDescription 1 | 1 | 2 | 3 |
ValueDescription 2 | 4 | 5 | 6 |
What would be the best way to get a table lik the following:
Date | ValueDescription | Value |
30.06.2021 | ValueDescription1 | 1 |
31.07.2021 | ValueDescription1 | 2 |
31.08.2021 | ValueDescription1 | 3 |
30.06.2021 | ValueDescription2 | 4 |
31.07.2021 | ValueDescription2 | 5 |
31.08.2021 | ValueDescription2 | 6 |
I hope you can help me.
Best regards
Manuel
Solved! Go to Solution.
Hi @Manuel123 ,
In Power Query, select your [Date] column, go to the transform tab and select the dropdown arrow next to 'Unpivot Columns', select 'Unpivot Other Columns', then rename your columns to whatever you want them to be.
Pete
Proud to be a Datanaut!
Hi @Manuel123 ,
In Power Query, select your [Date] column, go to the transform tab and select the dropdown arrow next to 'Unpivot Columns', select 'Unpivot Other Columns', then rename your columns to whatever you want them to be.
Pete
Proud to be a Datanaut!