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

Duplicate Query

Group Duplicated Query

Join grouped query to original, matching on PersonID AND Date/Time

Success!