Dynamically change column title based on vlookup different table

[ManuClaessens]

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

[petrovnikitamai]

query editor

try

1. table1: select to first 3 columns and use unpivot other columns

 

2. merge table1 & table2

3. pivot column (picture1 step3)

[ManuClaessens]

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

[petrovnikitamai · Accepted solution]

@ManuClaessens, fixed