Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
Solved! Go to Solution.
In Power Query, this is a Group By on ID with an aggregation for Max of Modified Date (All done via the interface)
In Power Query, this is a Group By on ID with an aggregation for Max of Modified Date (All done via the interface)