Forum Discussion
Self join to remove duplicate values
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 late...
Anonymous , 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/
amitchandak
Super User
Super UserAnonymous , 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/