Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
I must change a column for new heathers... Ihave this:
And I need this:
It must be as a table not as a matrix, because I'll do a Pareto after that in the same table
Regards
Solved! Go to Solution.
HI @Anonymous,
You can enter to query editor side and duplicate the raw query table as backup, then you can use pivot column feature to transform the table rows to columns.
Pivot columns - Power Query | Microsoft Learn
If you are confused about coding formula and detail operation steps, please share some dummy data and paste here with table format then we can simply copy these to test.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
HI @Anonymous,
You can enter to query editor side and duplicate the raw query table as backup, then you can use pivot column feature to transform the table rows to columns.
Pivot columns - Power Query | Microsoft Learn
If you are confused about coding formula and detail operation steps, please share some dummy data and paste here with table format then we can simply copy these to test.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
User | Count |
---|---|
78 | |
75 | |
62 | |
60 | |
47 |
User | Count |
---|---|
109 | |
95 | |
86 | |
79 | |
61 |