Get only one row per ID per DATEFIRST or MIN

[Anonymous]

Hello All,
I'm new to Power BI and I need help please.
I have a table that looks like this : 

ID	PurchaseDate	Amount
A1	01/11/2027	100
A1	02/08/2022	300
A1	01/11/2022	300
A2	01/03/2021	850
A3	01/01/2024	110
A3	01/04/2022	450
A3	03/09/2024	150
A3	01/08/2023	150
A5	08/08/2022	690

I would like to retrieve the IDs with the next purchase date after indicating it in my slicer date table.

Let's imagine that I indicate in my slicer 01/08/2022
An example of what I would like to have:

ID	PurchaseDate	Amount
A1	02/08/2022	300
A3	01/08/2023	150
A5	08/08/2022	690

I tried to create a measure with FIRSTDATE(PurchaseDate) , but the problem is that when IDs have the same amount it returns me:

ID	PurchaseDate	Amount
A1	02/08/2022	300
A1	01/11/2022	300
A3	01/08/2023	150
A5	08/08/2022	690

Thanks for your help.
BR.

[Jihwan_Kim · Accepted solution]

Hi,

Please check the attached pbix file.

All measures are in the attached pbix file.

Thanks.