Forum Discussion

droecher's avatar
droecher
Regular Visitor
3 years ago
Solved

Powerquery: creating a new subset table by last date

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...
Need Help
  • smpa01's avatar
    smpa01
    3 years ago

    droecher 

    Table.SelectRows(#"Changed Type", let latest = List.Max(#"Changed Type"[#"snapshot-date"]) in each [#"snapshot-date"] = latest)
smpa01's avatar
smpa01
Community Champion
3 years ago

droecher 

Table.SelectRows(#"Changed Type", let latest = List.Max(#"Changed Type"[#"snapshot-date"]) in each [#"snapshot-date"] = latest)
droecher's avatar
droecher
Regular Visitor
3 years ago

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.