Create a new Measure for Date that will look for lowest running time in table

[AnonGAUser]

Hi, I have a table(allruns) and I want to create a Measure to look for the lowest running time in the table, after a specified date(01/01/2022) and then give me that date to use in a card.  So, in my example, I am looking for the measure to locate the lowest run time after 01/01/2022, which would be 86.97 on the botton row and I want it to return to me the date, whcih is 8/16/25 in this example.  

This is the expression I have created from info found online, but it isn't working correctly:

Fastest 10k run after 2021 =

CALCULATE(

    MIN(allruns[date]),

    FILTER(

        allruns,

        allruns[time] = CALCULATE(

            MIN(allruns[time]), FILTER(allruns,

            allruns[date] >= 1/1/2025  

        )

    )

)

)

Is anyone able to come up with an expression that will work properly?  thanks

Table(allruns):

[AnonGAUser]

Thanks!  That helps so much!  

[Royel · Accepted solution]

Hi @AnonGAUser  you can try this 

Date with Min Runtime = 
VAR MinRunTime = 
    CALCULATE(
        MIN(allruns[Runtime]),
        allruns[Date] > DATE(2022,1,1)
    )
VAR EarliestDateWithMinTime = 
    CALCULATE(
        MIN(allruns[Date]),
        allruns[Runtime] = MinRunTime,
        allruns[Date] > DATE(2022,1,1)
    )
RETURN
    EarliestDateWithMinTime

in this two stage dax, the goal is find the Min runtime first and then filter by runtime and date to get the exact date. 

Thanks 

If it helps give a like.