Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Friends,
I want to transform the below table in POWER Query :
Date | ABC | DEF | GHI | JKL | MNO |
Jun-1981 | 2608351 | 1958717 | 1178447 | 653940 | 657249 |
Sep-1981 | 2616060 | 1964139 | 1189946 | 655136 | 663047 |
Dec-1981 | 2624579 | 1969349 | 1200504 | 657014 | 667381 |
Mar-1982 | 2634534 | 1975617 | 1210128 | 658840 | 672273 |
into :
SID | Date | Volume |
ABC | Jun-1981 | 2608351 |
DEF | Jun-1981 | 1958717 |
GHI | Jun-1981 | 1178447 |
JKL | Jun-1981 | 653940 |
MNO | Jun-1981 | 657249 |
ABC | Sep-1981 | 2616060 |
DEF | Sep-1981 | 1964139 |
GHI | Sep-1981 | 1189946 |
JKL | Sep-1981 | 655136 |
MNO | Sep-1981 | 663047 |
ABC | Dec-1981 | 2624579 |
DEF | Dec-1981 | 1969349 |
GHI | Dec-1981 | 1200504 |
JKL | Dec-1981 | 657014 |
MNO | Dec-1981 | 667381 |
ABC | Mar-1982 | 2634534 |
DEF | Mar-1982 | 1975617 |
GHI | Mar-1982 | 1210128 |
JKL | Mar-1982 | 658840 |
MNO | Mar-1982 | 672273 |
The idea is to make the data struture leaner i.e. less number of columns in the data tables.
Please suggest the exact steps that need to be performed to optimally achieve the above using power query.
Regards,
Srijith
Solved! Go to Solution.
In the query editor, select your Date column, then right click on the header and choose "Unpivot Other Columns".
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
In the query editor, select your Date column, then right click on the header and choose "Unpivot Other Columns".
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
User | Count |
---|---|
90 | |
74 | |
67 | |
63 | |
55 |
User | Count |
---|---|
99 | |
88 | |
72 | |
60 | |
59 |