Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Nested MIN/MAX

Hello   I have the table: Col1 Col2 Col3 A 1 01/01/2000 A 2 02/01/2000 A 1 03/01/2000 A 2 04/01/2000 A 1 05/01/2000 A 1 06/01/2000 A 1 07/01/2000 etc  ...
Need Help
Tutorial Requests
  • danextian's avatar
    danextian
    4 years ago

    Are you expecting this kind of result?

    You can use the measures below:

    Earliest Date = 
CALCULATE ( MIN ( Data[Col3] ), Data[Col2] = 1, ALLEXCEPT ( Data, Data[Col1] ) )
    Latest Date = 
CALCULATE ( MAX ( Data[Col3] ), Data[Col2] = 2, ALLEXCEPT ( Data, Data[Col1] ) )

     

danextian's avatar
danextian
Super User
4 years ago

Are you expecting this kind of result?

You can use the measures below:

Earliest Date = 
CALCULATE ( MIN ( Data[Col3] ), Data[Col2] = 1, ALLEXCEPT ( Data, Data[Col1] ) )
Latest Date = 
CALCULATE ( MAX ( Data[Col3] ), Data[Col2] = 2, ALLEXCEPT ( Data, Data[Col1] ) )