Dynamic slicer to show only latest duplicate in visual

[JaroslavHlavka]

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.