Power Query - Dynamically Set Query Header Titles

Power Query - Dynamically Set Query Header Titles

9.954 Lượt nghe
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/powerquery-m/table-columnnames List.PositionOf https://learn.microsoft.com/en-us/powerquery-m/list-positionof List.FirstN https://learn.microsoft.com/en-us/powerquery-m/list-firstn Record.ToList https://learn.microsoft.com/en-us/powerquery-m/record-tolist List.Zip https://learn.microsoft.com/en-us/powerquery-m/list-zip Table.RenameColumns https://learn.microsoft.com/en-us/powerquery-m/table-renamecolumns my site https://www.basensei.com