Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I have the following table:
col.A | col.B | col.C |
item1 | x | y |
item2 | z | w |
I'd like to transpose as following
col.A | Col.b |
item1 | x |
item1 | y |
item2 | z |
item2 | w |
Is it possible to do it in PowerBI in an easy and fast way? In my final table I have a lot of rows and columns.
Thanks
Solved! Go to Solution.
@matteog , refer if these can help
Transpose : https://yodalearning.com/tutorials/power-query-helps-transposing-data/
https://radacad.com/pivot-and-unpivot-with-power-bi
@matteog , refer if these can help
Transpose : https://yodalearning.com/tutorials/power-query-helps-transposing-data/
https://radacad.com/pivot-and-unpivot-with-power-bi
User | Count |
---|---|
98 | |
90 | |
83 | |
70 | |
67 |
User | Count |
---|---|
113 | |
104 | |
101 | |
73 | |
65 |