Power Query - Dynamically Set Query Header Titles

Not all Datasets you'll receive will enable you to just use the first row of data as a table header without any hard coding. In this video i demonstrate how you can dynamically set your Query Header Titles - using some really awesome Power Query functions.
#powerbi #powerquery #mquery #m #dataanalytics #data
Links
Table.ColumnNames
learn.microsof...
List.PositionOf
learn.microsof...
List.FirstN
learn.microsof...
Record.ToList
learn.microsof...
List.Zip
learn.microsof...
Table.RenameColumns
learn.microsof...
my site
www.basensei.com

[@michaelangellotti5741]

Started a VBA project requiring importing data from many various reports that are Excel exports from their systems. Power Query is a large part & becoming a larger part of the automated process that is replacing VBA to meet the requirements. Your videos are well done & you don't waste my time. Many thanks and keep up the great work!

[@basensei8699]

thats Glorious Michael! power query is just excellent!

[@joelabacherli1310]

So much fun navigating a problem and getting to the end. This is such an awesome video. It really shows how far reaching power query truly is. It’s videos like this that are compelling me to do the same with my colleagues. Thank you for the content. I really enjoyed it.

[@basensei8699]

Thanks so much!

[@tterrabend]

💖@1:07 "I love Power Query, by the way." Me, too! And your videos are helping me love it even more! Thank you!

[@Sumanth1601]

Brilliant 😮, I did use transpose and fill options..but this is better 😊

[@FernandoGallego-s4o]

this was super helpful thanks!

[@bakoubak5489]

Thanks great

[@basensei8699]

Most welcome

[@stevencaldwell5782]

🤤 *Promo SM*