Rename first N columns in Power Query

In this video, we show you how to form a dynamic rename columns feature using applied steps to form intermediate variables that will be used in later parts of the M code!

To provide a solution, we use a bit of advanced #M coding and explain how to use the List.Zip function to create a list of nested lists, but it is an extremely interesting topic!

You can download the working file here:

#powerquery #powerbi #etltools #data #dataanalysis

[cosladacity]

wowwww!!! this is good stuff!! thankss

[alfredo.salvadora]

Awesome. Thanks so much for this valuable tutorial. You successfully made a complicated concept into a very simple and understandble way.

[elaf]

Great & very instructive video 👏-Thanks a lot. 1 additional "improvement" could perhaps to remove null value from the 2 Lists of 2 lines of Original Headers instead of using position a specific value ("Jan")

[pierreruwet]

Thanks for the share and the idea . Some question, the source is called multiple times in this query, does a table.buffer improve running time of the query. Also the Table.ColumnNames result is called two times, so could be store as step name bout does it change something about query running time?

[MrWella]

Thanks for the greate tutorial, this helps me a lot 👌

[pittwood]

Yes! Very enjoyed! 🤓Thanks for sharing, now magic is real!

[zackcarter]

Thank you for the tutorial. Do you have the workbook that you can share so we can delve into your steps?

[SaniGarba]

Thank you for this helpful tutorial. Please, how would the code change if, say, the changing columns are among the Jan to Dec and not the first three. Thanks.