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

Keep Duplicate Records in Power Query

1 Mins read

Power Query in Power BI allows you to perform a series of steps to transform your data. One of the steps amongst this is to keep duplicate records.

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)

Keep Duplicate Records In Power Query

We generally take out duplicate lines but if we need to keep and check what the duplicates are, Power Query allows us to do that. Suppose you have a set of data as shown in the below image. You can see that the marked ones are duplicate values, let’s keep them.

DATA WITH DUPLICATE RECORDS

Step 1: Go to Power Query Editor from Power BI Desktop

Get Data > Excel file > Load > Excel Data > Home > Edit Queries

Step 2: Keep the duplicate rows in Power Query Editor

Go to Home > Keep Rows button > Keep Duplicates option

KEEP DUPLICATE RECORDS

Step 3: Close & Apply Changes

Click on the Close & Apply option from the Home tab and this will apply all the pending changes on your data. When you open the file again, it will be saved as it is.

DUPLICATES KEPT USING POWER QUERY EDITOR

If you want to learn more about Power Query? Yoda Learning provides high quality fully updated Power Query Course that will make you Excel Power Query Hero at the office. This training will provide the latest trends and technical approaches in Power Query with Excel and Power BI.

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…