Recover the last date according to a slicer

[JbPa33]

Hello,

I am realising a power BI rapport and I am blocking on a date problem : 

I have a first table which lists the different amounts for a project numero. I want to created a second table where I recover the last amount from the first table. In this example, in the second table, i would like to have 213L183301 - 616 918,53. If I select date_comptabilisation between 01/07/2020 and 31/12/2020, i would like that the second table displays 414 281.06.

Is there a way to solve this problem ?

Thank you !

[JbPa33]

Thank you so much, it's exactly what I wanted !

[rbriga · Accepted solution]

I've created a measure that yields 1 or 0:

Max Date Filter = 
VAR _MaxDate = 
    CALCULATE(
         MAX(Table1[Date])
        ,ALLSELECTED(Table1[Date])
        , KEEPFILTERS(Table1[Project] = SELECTEDVALUE(Table1[Project]))
    )
RETURN
CALCULATE(
    IF(SELECTEDVALUE(Table1[Date]) = _MaxDate,1,0)
    , KEEPFILTERS(Table1[Project] = SELECTEDVALUE(Table1[Project]))
    )

Now, add this measure to the visual's filter:

Victory!