Question

You are preparing a customer dimension in a Dataflow Gen2. The source "Country" column contains inconsistent values such as "USA", "U.S.A.", "United States", and "us" that should all resolve to a single standardized value. You want to consolidate these variants to the canonical value "United States" with minimal manual mapping, tolerating minor spelling differences. Which Power Query transformation should you apply?

Accepted Answer

Use the Cluster values / fuzzy grouping option to group similar text values under a canonical representative

Answer

Use the Replace Values transformation once for each known variant of the country name

Answer

Use the Group By transformation on the Country column with a Count aggregation

Answer

Use the Detect Data Type transformation to convert the Country column to a categorical type