Power BITutorials

How to do Duplicate Columns in Power Query

1 Mins read

You can also duplicate the columns easily using the Power Query Editor in Power BI. This can be helpful when you have columns that you want to duplicate & make some temporary/permanent alterations to it in the Power Query Editor but not to your source data. In this tutorial, we learn 3 cool steps to duplicate columns with power query.

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)

Duplicate Columns Using The Power Query Editor

Suppose you have the source data as shown below. Here, the marked column is the one that we want to duplicate.

Step 1: Select the Column that you want to duplicate

After you load the data source into the Power Query Editor, you have to find the column that you wish to duplicate and select the same. As shown in the picture below, we are going to duplicate the salary column.

DUPLICATE COLUMNS

Step 2: Duplicate the selected column

When you select the column to be duplicated, the go-ahead to do the following changes on the ribbon.

Go to Add Column tab >Duplicate Column option

DUPLICATE THE SELECTED COLUMNS

Step 3: Save Data

After you duplicate the column you get the result immediately on the screen of the Power Query Editor. When done with your work, just click on the save icon on the top to save the changes for next time.

DATA TABLE WITH DUPLICATED COLUMN

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…