Min and Max

[Tito]

Hello,

Hope everyone is having a nice day.

Would someone be able to help me with a DAX formula please?

I want to calculate difference between maximum and minimum. I'm having trouble calculating the minimum.
In this case, the minimum is not the earliest date, but the closest (minimum +1).

For example, if I select the year 2017 from the "Year" column, my minimum in the Date column is 02/15/2020 and not 11/20/2019.

For example, if I select the year 2018 from the "Year" column, my minimum in the Date column is 03/21/2020 and not 12/20/2020

[amitchandak]

@Tito , Assume you have both of them in a table

calculate(Min(Table[Date]), allexcept(Table, Table[Year])

or

calculate(Min(Table[Date]), filter(allselected(Table) , Table[Year] = max(Table[Year]) ) )