NEW! FREE 90 Minutes Excel VBA Course for Beginners! Watch now 

Power BITutorials

Steps to Remove Columns Using Power Query

1 Mins read

Another feature of Power Query is Remove Columns. This feature allows you to remove the unwanted columns easily.

Learn Steps to Remove Columns By Power Query

This is helpful when you have columns that you want to eradicate and do not need in your final report – but do want to keep in your source data.
 

Suppose you have the following source data. As you can see that the marked column is the one we want to remove, so let’s get rid of it.

Step 1: Select the columns you want to remove

As shown in the picture below, we have a data table showing the details for employees. If we want to share these details, we need to hide the confidential data like salary. Therefore we want to delete the Salary p.a. column from Power Query but keep the same in source data.

The very first step is to select the column that we want to remove from Power Query as shown in the picture below.

TIP: Press and hold the CTRL key to select multiple columns.

SELECT TO REMOVE COLUMNS

Step 2: Remove the unwanted columns

To remove the unwanted columns, go to

Home > Remove Columns button > Remove Columns option

 REMOVE COLUMNS

Step3: Close & Apply

Observe the result and check whether it is as per your expectations. Then click on the Close & Apply button to close the Query Editor and apply any pending changes. The picture below shows the final output.

 

DATA TABLE AFTER REMOVING COLUMNS

You can learn more :

Related posts
Power BITutorials

Opportunity Analysis Power BI Dashboard

1 Mins read
Information: A software company that has two sales channels: direct and partner. The sales manager created this dashboard to track opportunities and…
Power BITutorials

Procurement Analysis Power BI Dashboard

1 Mins read
Information: It analyzes a manufacturing company’s spending on vendors by category and location. we explore these areas: Who the top vendors are…
Power BITutorials

Retail Analysis Power BI Dashboard

1 Mins read
Information: It analyzes retail sales data of items sold across multiple stores and districts The metrics compare this year’s performance to last…