Forum Discussion

florent-3628's avatar
florent-3628
Frequent Visitor
7 years ago
Solved

Remove duplicate with date condition

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 d...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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.

florent-3628's avatar
florent-3628
Frequent Visitor
7 years ago

Thanks a lot ; it works !