As a business intelligence analyst, there is no better feeling than saving time on a task. And this tip will save you some time while working on the Power Query Editor.
Say you gathered your data set and is now displayed on Power Query Editor. Now, you would like to alter one of the columns in the data set.
A natural approach (one very common in my organization) is to scroll to the right using the horizontal scroll bar. With large data sets, this approach can be difficult because the column may be located somewhere in the middle of dozens of columns!
Instead, you can use the Go to Column command in Power Query Editor:
-
Go to Home > Choose Columns. Click on the lower half of the icon. Then select Go to Column.
-
Once the Go to Column pane appears, either select the column or search for the name of the column and then select. Click OK.
Power Query Editor will then take you to the column selected.
