Forum Discussion

Tito's avatar
Tito
Icon for Helper IV rankHelper 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 calculati...
Dashboards
amitchandak's avatar
amitchandak
Icon for Super User rankSuper 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]) ) )