Pull Max Effective Row for Associates

Summary

Return only the most current row for a list of active and terminated associates

Content

I'm trying to build a report to pull the most current data for a list of associates. When i use the MAX aggregate it gives me the max data per department and not just the most recent row of data, which is what i want to see. I'm building this off of the Worker Assignment Event Real Time subject area. Should i be using a different subject area or is there a different way that i can create this?