Forum Discussion
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 | 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.
2 Replies
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.
