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?
Solved! Go to 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])))
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])))
Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.
Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!
Join the biggest FREE Business Applications Event in LATAM this February.