Dynamic Column Names in Power Query

Learn how to create dynamic column names in Power Query using a mix of Table.RenameColumns() and Table.ToColumns() function.

- - - - My Courses - - - -
✔️ Mastering DAX in Power BI -

✔️ Power Query Course-

✔️ Master Excel Step by Step-

✔️ Business Intelligence Dashboards-
- - - - Blog - - - -

[jaymehta]

Thank you for sharing this. Dynamic columns is such a relief, especially for the data that keeps expanding horizontally or last x months/quarters etc.

[woodstock]

Brilliant. Thank you. I like how you carefully explain what is going on in the code as you proceed so I don't just know how to do it, I understand what I'm doing! 🙂

[russo]

Thank you so much! and also because you explained that maybe something can go wrong when you create another step, it's so important, at least for me because I'm new in this learning

[Praaxx]

Thank you for sharing this tip. Exactly what I needed!

[michajlo]

Absolutely awesome solution. Saved me a lot of time. Thanks a lot for sharing!

[jah]

Dude. You cleared up several things for me after many years with PQ/BI. Many thanks.

[tlee]

Thank you for making this tutorial so clear.

[philvittetoe]

Great video, mate - saved me a lot of time and adds a great level of functionality for the process improvement I'm working on.

[bmnovtp]

Thank you so much! After going through several solutions without success, your video really made it clear and it worked for my case!

[zeemahs]

Clear and concise. Thanks for the video!

[justinwduff]

Excellent content, will definitely be checking out your course!

[MilhouseBS]

Nice explanation. This sort of dynamic renaming is necessary to make queries robust.

[ssmith]

I can’t thank you enough! Great job and explained wonderfully!

[mohamedmossad]

Neat Trick. Good exercise.
I think I can use Table.ToRows instead of Table.Transpose and Table.ToColumns.
Thank you.

[SuperDarekR]

Thank you so much! The best way to change columns name

[AweshBhornya-ExcelforNewbies]

Awesome. Looks like the trend is to learn power query and the m language for better results in data modeling. Thanks

[ExcelInstructor]

Actualy you could fix the last problem by simple code. table.columnnames, from that grab the last row (remember PQ is 0 based) so use [new col]{2} to dynamicly set that column.

[mahadevshah]

Thanks a ton for this video, it worked for me. You are awesome Chandeep.

[IconicLemon]

Thank you, this is the perfect solution I was looking for.

[jamespyle]

This is pretty cool, works great. I had issues when trying to use it with a connection that references it's own output though.