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 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 with different timestamps. I would like to remove them in Power Query by saying: if there are multiple rows with the same ID, keep only the one with the minimum Timestamp. The ID column should in the end be the primary key of the table. I would be able to do this in DAX but I'm not capable of doing that in M.
Thanks for any help.
Solved! Go to Solution.
You can achieve that by doing the following steps:
You can achieve that by doing the following steps:
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 |
---|---|
102 | |
53 | |
21 | |
13 | |
11 |