showing only last record per group based on date slicer

[Rbie]

Hi all,

I have the following data

ID	RNK	Date
1	1	1/03/2024
1	2	1/02/2024
1	3	1/01/2024
2	5	1/05/2024
2	4	30/04/2024
2	3	1/04/2024
2	2	1/03/2024
2	1	1/01/2024
3	1	1/04/2024
3	2	1/02/2024

I want to show the latest record per ID based on the date choosen in a slicer,  so if someone chooses 1/2/2023 it would show

1	2	1/02/2024
2	1	1/01/2024
3	2	1/02/2024

in case of 1/4/2024, it would show

1	1	1/03/2024
2	3	1/04/2024
3	1	1/04/2024

Anyone have an idea how to achieve that?

Thanks In advance,
Rbie

[amitchandak · Accepted solution]

@Rbie , refer the blog how to get latest

https://amitchandak.medium.com/power-bi-get-the-last-latest-value-of-a-category-d0cf2fcf92d0

https://amitchandak.medium.com/power-bi-get-the-sum-of-the-last-latest-value-of-a-category-f1c839ee8...