Power Query 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.

DOWNLOAD EXCEL WORKBOOK

 

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.

 

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

 

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

 

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

 

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

 

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:

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

How To Install Power Query in Excel 2010  Power Query is a new add-in that was introduced in Excel 2013 by Microsoft and was that popular that they made it backward compatible with Excel 2010.CLICK TO SEE THE TUTORIAL ON HOW TO INSTALL POWER QUERY IN EXCEL 2013  So what is Power Query? We...
Remove Columns Using Power Query or Get & Tra... Power Query (in Excel 2010 & 2013) or Get & Transform (in Excel 2016) lets you perform a series of steps to transform your Excel data.One of the steps it allows you to do is to remove columns easily.This is helpful when you have columns that you want to eliminate ...
Remove Duplicates Using Power Query or Get & ... Power Query or Get & Transform (In Excel 2016) lets you perform a series of steps to transform your Excel data.  One of the steps it allows you to take is to remove duplicates easily. This removes the human error whenever you try to delete your duplicate data manually!Let...
Import Data from Text Using Power Query or Get �... Power Query or Get & Transform (In Excel 2016) lets you perform a series of steps to transform your Excel data.But what if your data source is not in your Excel spreadsheet?If it's inside a text file, it's very easy to import data from text and right into Power Query!...