Power Query - Dynamically Sort Table Columns by user input
Вставка
- Опубліковано 8 вер 2024
- In this video i show you how to dynamically change column order based on user input. And if no user input is provided the columns are sorted alphabetically.
#dataanalytics #data #mquery #powerbi #powerquery #excel #exceltips #exceltutorial
Follow along File
github.com/jbo...
Noteworthy techniques
- Using muliple tables to sort and create table headers
Table.ReorderColumns
powerquery.how...
Table.ColumnNames
powerquery.how...
Amazing and smooth trick. Have to note this one in my notepad++ for PQ tricks =) thanks!
Excellent as always. Thanks James
Super awesome video! Thank you creating/sharing this!
Thanks James, Glad you managed to fix your audio problem:)
thanks for pointing it out last time! my new mic setup was incorrect! :)
This is awesome, thanks James!
Glad you liked it!