You are currently viewing What’s the difference between Distinct and Unique? Power Query Data Profiling

What’s the difference between Distinct and Unique? Power Query Data Profiling

Data profiling lets you have a quick overview of your data. There are three options in Power BI data profiling:

  • Column quality,
  • Column value distribution and 
  • Column profile.

However, today we will look at just column distribution, but let’s see how to activate data Profiling in Power Query.

How to activate data Profiling in Power Query?

  1. Open Power Query Editor
  2. Go to View
  3. Check Column Distribution under Data Preview

If you notice, there are other options in the Data Preview box:

  • Show WhiteSpace visualise any whitespaces in data.
  • Monospaced displays your data in a Monospaced font.
  • Column quality tells you how valid your data is, are there any errors or empty cells in that column?
  • Column Profile gives statistical information-count, error, empty, distinct, min, and max-about the distribution of your data.

Column distribution

This feature provides you with quick insight into your data by showing the frequency and distribution of the values in your columns. 

You can also hover over the distribution visuals to see the same details. The frequency and distribution of the values in your columns are shown as “Distinct” and “Unique.”

What’s the difference between Distinct and Unique?

Though these two words sound similar, they are quite different. 

Distinct shows how many values are in the column if you remove the duplicate, while Unique shows how many values appeared just once.

Let’s look at the fruit data we have. There are ten items on the list; however, only five are distinct. The five distinct fruits—mango, pineapple, oranges, grapes, and apples—represent our five different fruit types. The only items that appeared just once were apples and grapes, representing the two unique values.

You could watch this comprehensive video to learn more about data Profiling.

For more about Excel, SQL, Python, and Power BI keep up with UrBizEdge Blog and Subscribe to our YouTube channel.

 

Leave a Reply