Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have created a function which renames my columns based on the criteria I need with numbers in all the column headers.
So I need to order these columns based on these numbers in ascending order. See the below code where I manually ordered the columns.
Table.ReorderColumns(RemoveColumns,{"Viewfolder 1", "Viewfolder 2", "View 2", "Viewfolder 3", "View 3"})
This is a sample case with just 5 columns, but I have excel files with 100's of columns to order.
I prefer it if "viewfolder" is placed before "view", but it's not mandatory. Is there any way to achieve this using "M"
Solved! Go to Solution.
You should be able to add a new step in Power Query as follows:
Home > Choose Columns > Select All Columns > Sort A-Z > Name
as shown in the YouTube video Easy Trick for Sorting Columns in Power Query
User | Count |
---|---|
103 | |
91 | |
79 | |
72 | |
68 |
User | Count |
---|---|
108 | |
96 | |
95 | |
74 | |
71 |