Power Query - Reorder Column(s) by Position
Learn how to move a column (or columns) to specific positions while producing a stable query resistant to data changes. Plus, learn some M Code optimization tricks.
File Download Link:
https://www.bcti.com//wp-content/YT_D...
00:25 Bringing in the Data
00:35 The "Normal" Method
00:47 Issues WIth Using the "Normal" Method
02:02 The "Stable" Way to Move a Column
02:41 Step 1: Building a List of Column Names
03:03 Step 2: Removing the Column to be Moved
04:09 Step 3: Add the Moved Column Back to the List
05:04 Step 4: Reorder the Columns Based On the List
05:42 M-Code Optimization
06:39 M-Code Comparisons