Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |