Please note javascript is required for full website functionality.
MVP

Blog

Power Query: Unique and Distinct

25 March 2020

Welcome to our Power Query blog.  This week, I look at how to find the unique or distinct values in a list of data.

 

I have a list of data, and I want to find the values that occur once only.

My first step is to extract my data to Power Query using the ‘From Table’ option in the ‘Get & Transform section of the Data tab.

I begin by using the ‘Group By’ feature on the Transform tab.

I can accept the defaults:

This will count the number of times each Data value appears. 

I only want to see the Data values that appear once.  I can do this by filtering Count.

I click OK to see my unique data:

I can also find the distinct values from my original data.  I start from the original data again.

This time, I can right click on my column to find the distinct values.

I remove the duplicates:

I can see that I now have 99 distinct values out of the original 500 rows.

 

Come back next time for more ways to use Power Query!

Newsletter