Skip to main content
Power BI Interview Questions

What is the difference between distinct and unique values in Power Query’s column distribution?

Table of Contents

In Power Query’s Column Distribution, the difference between distinct and unique is as follows:

  • Distinct: Refers to the total number of different values in a column, regardless of how often they appear.
  • Unique: Refers to the count of values that appear only once in the column.

Add comment