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

[Anonymous]

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 item no. 0000.2121 only 1 row with transaction date 13/07/2023.

Can someone help me figure this out?

Thanks!

[HotChilli]

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]

Hi @HotChilli,

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