Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.