Forum Discussion
Remove duplicates and keep most recent date
Hello,
I have the following table in Power Query and i am trying to add step/s that would remove all duplicate Document ID's but keep only the corresponding most recent Modified Date. Is this possible? Any help is much appreciated!
| Document ID | Modified Date |
| 3998 | 14/09/2022 |
| 4050 | 04/08/2022 |
| 4050 | 01/08/2022 |
| 4060 | 10/07/2022 |
| 4060 | 22/07/2022 |
| 4139 | 20/07/2022 |
| 4145 | 15/07/2022 |
| 4145 | 05/07/2022 |
| 4145 | 05/07/2022 |
| 4160 | 15/07/2022 |
| 4160 | 06/07/2022 |
| 4164 | 25/09/2022 |
| 4164 | 25/09/2022 |
| 4187 | 15/07/2022 |
| 4187 | 23/10/2022 |
| 4187 | 08/09/2022 |
| 4187 | 05/08/2022 |
Expected results:
| Document ID | Modified Date |
| 3998 | 14/09/2022 |
| 4050 | 04/08/2022 |
| 4060 | 22/07/2022 |
| 4139 | 20/07/2022 |
| 4145 | 15/07/2022 |
| 4160 | 15/07/2022 |
| 4164 | 25/09/2022 |
| 4187 | 23/10/2022 |
In Power Query, this is a Group By on ID with an aggregation for Max of Modified Date (All done via the interface)
1 Reply
In Power Query, this is a Group By on ID with an aggregation for Max of Modified Date (All done via the interface)