Filter Based on category and latest datetime

[Anonymous]

I have a dataset that consist of different period and SOP Cycle with different product and different datetime. I would need to filter this dataset in Power Query based on their latest datetime and from each SOP Cycle. This is sample data that I have. Would appreciate any solution on this.

[wdx223_Daniel · Accepted solution]

NewStep=Table.FromRecords(Table.Group(PreviousStep,{"Period","SOP_Cycle","Product"},{"n",each Table.Max(_,"Datetime")})[n])