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.
All,
I'm looking for a way to change the column title based on a vlookup of a different table.
More specifically, this is how the raw data looks like:
Then, I would like powerbi to lookup the column title value 'F000000000000000000100000000000000000000' in below table, and rename the column title to the value associated in below table:
Can anyone guide me in how to accomplish this?
Thanks!
Manu
Solved! Go to Solution.
query editor
try
1. table1: select to first 3 columns and use unpivot other columns
2. merge table1 & table2
3. pivot column (picture1 step3)
Dear Petrov,
Thanks for your quick reply.
Any chance you can put your powerbi in English?
As I can't read the language, tough to understand exactly what I need to do.
Appreciated!
Manu
User | Count |
---|---|
77 | |
74 | |
63 | |
61 | |
45 |
User | Count |
---|---|
108 | |
102 | |
93 | |
83 | |
64 |