2022 updates MS Excel - Data Cleaning Course Enroll now  
Power BITutorials

Advanced Editor With Power Query

1 Mins read

Advanced Editor With Power Query can perform a lot of complex steps with any kind of data source. However wouldn’t it be fun unless you understand what is happening under the cover? This Power Query Tutorial will help you to understand how to use Advanced Editor. These complex steps are well explained by our Power Query Training Experts so beginners can easily understand and implement.

Data Analytics Tricks in Power BI – Guidebook

You too can analyze data like a Data Scientist. No coding needed. No statistics needed.

Analyze & Visualize data using Power BI. (23 tricks in one book)

Advanced Editor With Power Query

Let’s go through the steps in detail to understand the magic of Power Query.

Step 1: Load the data into Power Query Editor

To understand the working of Power Query, first, load the data in Power Query as shown below.

DATA TABLE LOADED IN POWER QUERY

Step 2: Add Index Column

Now, make some changes to your data table. In this example, we have added an Index column to the data table.

To add Index column, go to-

ADD INDEX COLUMN

After adding Index Column, the data table looks like this:-

AFTER ADDING INDEX COLUMN

Step 3: Rearrange the Index Column

To rearrange the Index column just drag it and place it wherever you want. Here, we have placed it to the beginning as shown in the below picture.

AFTER REARRANGING COLUMNS

Step 4: Change Header Type

To change the header type of the newly added column, click on the down arrow on the column header and click on the Whole Numbers option.

CHANGING HEADER TYPE

After changing the header type, your data table will look like this-

AFTER CHANGING HEADER TYPE

Step 5: View the steps applied in the Applied Steps Window

You can see the Applied Steps for adding Index Column to your data table. The steps are broken down as follows:

  • SOURCE: Get the Source Table
  • NAVIGATION: Navigate through all the sheets
  • CHANGED TYPE: Changed the type of columns in the Table
  • ADDED INDEX: Added an Index Column
  • REORDERED COLUMNS: Rearrange the Index column
  • CHANGED TYPE1: Change the type of Index column in the Table

Step 6: Open Advanced Editor

To open the Advanced Editor, go to-

Home > Advanced Editor

OPEN ADVANCED EDITOR

You will now see the steps in Advanced Editor, in detailed form as given in the below picture.

ADVANCED EDITOR WINDOW

Here, you are able to see what’s happening under the hood of your Power Query transformations.

Data Analytics Tricks in Power BI – Guidebook

You too can analyze data like a Data Scientist. No coding needed. No statistics needed.

Analyze & Visualize data using Power BI. (23 tricks in one book)

Related posts
AlteryxTutorials

Alteryx Hotkeys - Alteryx Keyboard Shortcuts

2 Mins read
Top 50+ Alteryx Shortcuts for Windows. Alteryx is popularly known as a Self-Service Analytics tool. Business users can build their data workflows…
AlteryxTutorials

Step By Step Guide to Learn Alteryx

6 Mins read
Alteryx Learning Path: The growth in technology has resulted in growth in understanding. In today’s world, humans – fellow businessmen know the…
Excel VBA CodeTutorials

VBA Code to Clean the Date Format

1 Mins read
When it is useful? Most of the time the most annoying problem is when the data is taken from ERP or other…

1 Comment

Comments are closed.