Forum Discussion

HxH's avatar
HxH
Advocate II
6 years ago
Solved

Eliminate duplicate rows based on Timestamp

Hi all,  I have a table that among other columns has an ID and a Timestamp which records the moment when that row was created. For some reasons I'm not going to dive into some IDs are duplicated w...
Need Help
Tips and Tricks
  • stvsurf's avatar
    stvsurf
    6 years ago

    You can achieve that by doing the following steps:

    1. use a "group by" on "id" and select as operation "All Rows", let's assume you call the column "group"
    2. Add a custom column with formula: Table.Min([group],"date")
    3. Expand the custom column
    4. Expand group
    5. create a conditional column (show/hide) where you compare the date from the row with the expanded custom column (which is the minimum date per id)
    6. filter on show

    1.  

     

stvsurf's avatar
stvsurf
Resolver I
6 years ago

You can achieve that by doing the following steps:

  1. use a "group by" on "id" and select as operation "All Rows", let's assume you call the column "group"
  2. Add a custom column with formula: Table.Min([group],"date")
  3. Expand the custom column
  4. Expand group
  5. create a conditional column (show/hide) where you compare the date from the row with the expanded custom column (which is the minimum date per id)
  6. filter on show

  1.