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

 

Can someone help me figure this out?

 

Thanks!

 

 

Need Help

2 Replies

  • 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!