Self join to remove duplicate values

[raghushettyyy]

So I have 2 rows of data:

Customer name	Date
xyz	1/5/2021
xyz	2/5/2021
mno	1/3/2021
mno	5/3/2021
abc	7/6/2021

and I want to just take out the records for the latest date for each unique customer.

expected output:

Customer name	date
xyz	2/5/2021
mno	5/3/2021
abc	7/6/2021

and I'm unable to do so because I just have 2 rows and even though the customer names are the same but the dates are different it considers it as a unique record.

what should I do to get the expected output I have 12000 rows of such data.

[raghushettyyy]

Thank You, it worked. @amitchandak 

[amitchandak · Accepted solution]

@raghushettyyy , In visual you can take max of date with customer .

or you can create a new tbale

summarize(Table, [Customer], "Date", max(Table[Date]))

or refer this

https://exceleratorbi.com.au/remove-duplicates-keep-last-record-power-query/