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
https://learn.microsoft.com/en-us/pow...
List.PositionOf
https://learn.microsoft.com/en-us/pow...
List.FirstN
https://learn.microsoft.com/en-us/pow...
Record.ToList
https://learn.microsoft.com/en-us/pow...
List.Zip
https://learn.microsoft.com/en-us/pow...
Table.RenameColumns
https://learn.microsoft.com/en-us/pow...
my site
https://www.basensei.com