Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

First date calculation when status is first reached

Hello,   I am trying to figuring out how to calculate the first date an ID has reached a certain status. What do I mean with this?   I have a daily overview of multiple IDs with statusses and ev...
Need Help
  • parry2k's avatar
    parry2k
    6 years ago

    Anonymous try this

     

    Max Date = 
CALCULATE(
MIN( Table[Date] ),
ALLEXCEPT( Table, Table[Id] ),
Table[Status] = "Closed"
)
parry2k's avatar
parry2k
Super User
6 years ago

Anonymous try this

 

Max Date = 
CALCULATE(
MIN( Table[Date] ),
ALLEXCEPT( Table, Table[Id] ),
Table[Status] = "Closed"
)
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thank you! This really helped :)