Question

You are cleaning a customer dataset in Power Query. Before building relationships, you want to verify that the CustomerID column contains only unique values and identify how many distinct and duplicate values exist. Which column profiling feature in the Power Query Editor should you enable to see this information at a glance?

Accepted Answer

Column distribution, which shows distinct and unique value counts for the column

Answer

Column quality, which shows the percentage of valid, error, and empty values

Answer

Column profile, which shows detailed statistics such as min, max, and average

Answer

Monospaced font in the data preview, which aligns values for visual scanning