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 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.
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/
2 Replies
- amitchandak
Super User
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/
Thank You, it worked. amitchandak