Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 !
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
96 | |
80 | |
67 | |
62 |
User | Count |
---|---|
137 | |
106 | |
104 | |
81 | |
63 |