Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
Solved! Go to Solution.
Table.SelectRows(#"Changed Type", let latest = List.Max(#"Changed Type"[#"snapshot-date"]) in each [#"snapshot-date"] = latest)
Table.SelectRows(#"Changed Type", let latest = List.Max(#"Changed Type"[#"snapshot-date"]) in each [#"snapshot-date"] = latest)
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.