Pick last day from a table

[ThomasWeppler]

Hi power BI community

I have a table with three colums

1. Index: 

2. Assingmnent: Show the number of the assingment (Number)
3. Date: Show diffrent dates where the assinment had to be done.

So the table could look like this.

Index       Assingment         Date

1                1                        01-01-2021
2                1                        01-01-2022
3                1                        01-01-2023

In my repport I have a date filter that can pick a max date.
If I pick a max date of 10-10-2021 I want the report to show 01-01-2021
If I pick a max date of 10-10-2022 I want the report to show 01-01-2022

If I pick a max date of 01-01-2023 I want the report to show 01-01-2023

In other word I need some DAX code that allows my to get the highest date within a datefilter for the selected assingment.

All help is appreciated.

[amitchandak]

@ThomasWeppler , I think code in blog should help

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...