Excel Power Query | Find Most Recent Record (Grouping)

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


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 )

Facebook photo

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

Connecting to %s