Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Remove duplicates based on a column and keep rows with the earliest date

Hi Guys,   I want to remove duplicates for row 'Item'. and keep the row with the earliest date based on row 'Transaction Date'.   So in the picture showed below it should result for example with ...
Need Help
HotChilli's avatar
HotChilli
Icon for Community Champion rankCommunity Champion
3 years ago

In Power Query, select all columns except date, do a 'Group By' and select the Min date as an aggregation.  This will work if the rows are identical except for the Transaction date

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi HotChilli,

Unfortionately, this is not the case. Rows are not identical!