Forum Discussion
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...
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]) ) )