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 !

  • LucienF38's avatar
    LucienF38
    Helper I
    7 years ago

    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's avatar
    LucienF38
    Helper I
    7 years ago

    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 :)