hello everyone,
Looking for any ideas or directions for the following problem.
I have data sourced from Sharepoint list with version history:
ID Version VersionDate Amount
1 1 01/01/2023 100
1 2 01/02/2023 120
1 3 01/05/2023 90
2 1 01/03/2023 200
I have a slicer to filter out VersionDate "after" selected date. The table will show 1, 2 or 3 duplicates for ID=1 (depending on the date selected in the slicer). How to make the visual show only latest ID entry based on VersionDate (duplicates based on ID)?
Example output:
Slicer date selected: 01/03/2023
Expected output:
ID Version VersionDate Amount
1 2 01/02/2023 120
2 1 01/03/2023 200
Thanks in advance. really stuck on this one for some time now. googling only leads to removing duplicates in PowerQuery, which can't solve this.
