Forum Discussion

Tito's avatar
Tito
Helper IV
3 years ago

Min and Max

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


Dashboards

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    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]) ) )