Pinterest Pixel

Advanced Editor In Power Query

Power Query in Excel can let us perform a lot of complex steps with our data. However... read more

Download Excel Workbook
Bryan
Posted on

Steps To Follow

Overview

Advanced Editor In Power Query | MyExcelOnline Advanced Editor In Power Query | MyExcelOnline

Power Query in Excel can let us perform a lot of complex steps with our data.

However wouldn’t it be fun if you could understand better what is happening under the hood? Come join me as we take a look into the Advanced Editor!
We will use the Index Column Post as our starting point.  Please download the Excel Workbook below.

Advanced Editor In Power Query

Advanced Editor In Power Query | MyExcelOnline

Download excel workbookAdvanced-Editor.xlsx

 

Let’s go through the steps in detail:

STEP 1: For us to view the existing Power Query steps:

Go to Data > Get & Transform > Show Queries (Excel 2016) or

Go to Data > Get & Transform > Show Pane (Excel 2013 & 2010)

Now double click on the Table1 query.

Advanced Editor In Power Query

 

STEP 2: This will open up the Power Query Editor.

Advanced Editor In Power Query

 

You can see the Applied Steps we have with the Index Column workbook you downloaded above.  The steps are broken down as follows:

  • SOURCE: Get the Source Table
  • CHANGED TYPE: Changed the type of columns in the Table
  • ADDED INDEX: Added an Index Column
See also  Import Data from CSV Using Power Query or Get & Transform

Advanced Editor In Power Query

 

STEP 3: Now the fun part! Go to Home > Advanced Editor

Advanced Editor In Power Query

 

You will now see our exact 3 steps, in detailed form!

  • Get the Table1 as the Source
  • Change the Column Type of Sales Month to text, and Sales to number
  • Add a new index column called Index that starts at 1 and increments by 1

Advanced Editor In Power Query

 

You are now able to see what’s happening under the hood of your Power Query transformations!

Stay tuned as you join me in editing through the Power Query Advanced Editor next time!

 

HELPFUL RESOURCE:

Advanced Editor In Power Query | MyExcelOnline

If you like this Excel tip, please share it
Advanced Editor In Power Query | MyExcelOnline Advanced Editor In Power Query | MyExcelOnline

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...