Filter to most recent employee record

[shannon8000]

Hello!

I have a dilemna.  I have employee records where each time a change is made to their profile, a new record is generated.

With that, I need to filter for all to return only the most recently updated record for each. Below is a generic sample of what I am working with.  I need to be able to filter out the older records from the report view.  I've searched the forums and have not found something so specfic as this ask.  Basic and advanced filtering do not have applicable options in this scenario.  Longer term employees can have hundreds of records.

Employee	Unique Identifier	Record Last Modified
Smith, Joe	xchkihs	1/25/2024	9:35:20 AM
Smith, Joe	xchkihs	5/1/2024	10:35:17 AM
Steven, Sue	dkslsjs	12/1/2023	5:55:26 PM
Steven, Sue	dkslsjs	6/1/2024	7:37:15 AM

[shannon8000]

Thank you all!  Each of these options are great!😍

[ThxAlot · Accepted solution]

Simple enough,

[Ashish_Mathur]

Hi,

This M code works

let
    Source = Excel.CurrentWorkbook(){[Name="Data"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Employee", type text}, {"Unique Identifier", type text}, {"Record Last Modified", type datetime}}),
    #"Grouped Rows" = Table.Group(#"Changed Type", {"Employee"}, {{"Count", each Table.Max(_,"Record Last Modified")}}),
    #"Expanded Count" = Table.ExpandRecordColumn(#"Grouped Rows", "Count", {"Unique Identifier", "Record Last Modified"}, {"Unique Identifier", "Record Last Modified"})
in
    #"Expanded Count"

Hope this helps.

[Ahmedx]

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.