Forum Discussion
Filter Based on category and latest datetime
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.
NewStep=Table.FromRecords(Table.Group(PreviousStep,{"Period","SOP_Cycle","Product"},{"n",each Table.Max(_,"Datetime")})[n])
1 Reply
NewStep=Table.FromRecords(Table.Group(PreviousStep,{"Period","SOP_Cycle","Product"},{"n",each Table.Max(_,"Datetime")})[n])