Forum Discussion
Finding the most recent date/time for each row
My bad....Sorry i missed this point
Try this. See the attached file as well
Step 1: First Add a custom column to get the dates only without time.
=Int64.From([Dates])
Convert above integer to date format to get the date portion
Step 2: Group by ID and this DateOnly Column with Max of DateTime Column and All other rows
as follows
Step # 3: Now we use Table.Max function to get the other rows
Then expand table and remove unnecessary columns
Hi, I just found this as i'm trying to do the same thing so I opened your file - but I can see, that you still have three values for ID 1.
For my data, I want to only keep the ID 1 with the most recent date, and the other rows should not be present.
So in your example, at the end, I would only want to keep the highlighted rows.
Helper IAnonymous i have the same issue. the suggested solution does not really seem work. did you manage to find a way to get the latest date/time for each row?