🔥 3-day streak
Microsoft Power BI Data Analyst77 / 205
Question 77 of 205

You are cleaning a supplier dimension table in Power Query. You need to quickly determine how many distinct supplier IDs exist and how many are unique (appearing only once) across the full table, so you can decide whether the ID column is a valid key. Which Power Query feature should you enable to see the 'Distinct' and 'Unique' value counts for the column?

Reviewed for accuracy · Report an issueNext question