Resolved: Difference between Distinct and Unique?
Hello,
Please can you explain further with example for the difference between distinct and unique values in column distribution?
Doesnt both imply same meaning?
Hi, unique and distinct are not the same. Unique means values that exist only once in the dataset, distinct means values that are repeated several times. For example you can have today's date 20/04/2023 appear only once - meaning that it is unique, yesterday however appeared twice and the day before also appeared twice - meaning that they are distinct but not unique.
Thank you - Also please let me know for column profiling, its mentioned only for 1000 records its giving the details.
so if a file containers more than 1000 records, will it consider the top 1000 ? is there a way to get column profile for the entire record set?
it is the preview that only shows 1000 records, otherwise when displaying the values in the column profiling Power Query is looking across the entire dataset
Thank you!
Submit an answer
