Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
Solved! Go to 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.
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.
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 🙂
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 🙂
Thanks a lot ; it works !
User | Count |
---|---|
102 | |
91 | |
84 | |
77 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
75 | |
64 |