Forum Discussion
same customer id different name
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 ...
On way is create a new summarize table with min or max name
Customer = summarize(Table, Table[Customer Id], "Name",max( Table[Customer Name]))
On way is create a new summarize table with min or max name
Customer = summarize(Table, Table[Customer Id], "Name",max( Table[Customer Name]))
This works great amitchandak , thank you!!