Find Most Recent Record – Excel Power Query

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!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s