I have a big excel table, how do I find the most recent records by person?
I dealt with this recently. This documentation was helpful, but I still had to reason through some bits. So I put together this video in case you find yourself in the same situation.
Bring data into Power Query
Group Duplicated Query
Join grouped query to original, matching on PersonID AND Date/Time