same customer id different name

[Anonymous]

Hi all, I have this issue where I have the same customer id but customer names that were incorrectly typed in a dataset containing thousands of rows. I want to be able to filter on customer name for my end users of the report but cannot due to having multiple variations customer names for the same id.

Customer ID	Customer Name
123	Fred
123	Fredd
123	Fred.
123	Fred

Does anyone know of a workaround for this problem?

[amitchandak · Accepted solution]

On way is create a new summarize table with min or max name

Customer = summarize(Table, Table[Customer Id], "Name",max( Table[Customer Name]))

[Anonymous]

This works great @amitchandak , thank you!!