Powerquery: creating a new subset table by last date

[droecher]

Hello,

I have a table containing chronological snapshots of some data which keeps growing by adding new snapshots and adding new entries:

snapshot-date	entry-id	measurement
06/07/2023	001	some numerical value
06/07/2023	002	some numerical value
06/07/2023	003	some numerical value
06/01/2023	001	some numerical value
06/01/2023	002	some numerical value
05/15/2023	001	some numerical value
05/15/2023	002	some numerical value

I would like to create a NEW table which will only contain the entries from the LATEST snapshot, whatever that is:

snapshot-date	entry-id	measurement
06/07/2023	001	some numerical value
06/07/2023	002	some numerical value
06/07/2023	003	some numerical value

I assume this is basic stuff, but somehow neither google nor the other forum-entries have led me in the right direction.

Your help is much appreciated.

[smpa01 · Accepted solution]

@droecher 

Table.SelectRows(#"Changed Type", let latest = List.Max(#"Changed Type"[#"snapshot-date"]) in each [#"snapshot-date"] = latest)

[droecher]

Thank you - I just noticed, that the "filter latest" is available from the date filter options on the column, and it produced exactly the same code as your solution.