Forum Discussion

joshua1990's avatar
joshua1990
Post Prodigy
4 years ago
Solved

Relative Filter on last DateTime

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?

Need Help
  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    4 years ago

    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])))

     

1 Reply

  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    Most Valuable Professional
    4 years ago

    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])))