Relative Filter on last DateTime

[joshua1990]

Hi experts!

I have a historical table that has multiple records for each day.

Here we have a DateTime column (DD.MM.YYYY HH:MM:SS) that shows the DateTime key for the entry.

How can I filter this table to the last visible entry?

[Vijay_A_Verma · Accepted solution]

Insert this statement where #"Added Custom" is previous step and DateTime Column should also be replaced appropriately.

= Table.SelectRows(#"Added Custom", each [DateTime Column] = List.Max(List.Buffer(#"Added Custom"[DateTime Column])))