Remove duplicate with date condition

[florent-3628]

Hi,

I'm trying to remove duplicates in a table (column "id")  ; but i want to keep only the most recent .

Actually , even if i sort by date before using table.distinct ; the result keep an old date...

the table is like this

Version     id     date

v23	A	02/03/2019
v23	B	02/04/2019
v24	A	05/04/2019
v24	B	06/04/2019
v25	A	24/05/2019
v25	B	25/05/2019

The actual result after table.distinct :

v23	A	02/03/2019
v23	B	02/04/2019

The result i want :

v25	A	24/05/2019
v25	B	25/05/2019

[Anonymous · Accepted solution]

In Edit Queries make sure to filter descending on date. 

Then add 

    #"Buffer Table" = Table.Buffer(#"Sorted Rows")
in
    #"Buffer Table"

to the advanced editor

After that use remove duplicates on ID, it will remember the order and keep v25.

[LucienF38]

Hi @Anonymous ,

I have the same issue but I want to do it in DAX because I want to keep only the earliest rows from a concatenate create in DAX from 2 different tables... Do you have any idea on how to remove the duplicates but only the latest ones ? 

Thanks 🙂 

[LucienF38]

Hi @Anonymous ,

I have the same issue but I want to do it in DAX because I want to keep only the earliest rows from a concatenate create in DAX from 2 different tables... Do you have any idea on how to remove the duplicates but only the latest ones ? 

Thanks 🙂 

[florent-3628]

Thanks a lot ; it works !