Forum Discussion

Fro88er's avatar
Fro88er
Icon for Helper IV rankHelper IV
5 years ago
Solved

Prior Date at each ID, Per Sequence

I am trying to figureout the days to redeploy a candidate. First I need the [dateBegin] from next placement to be on the same row as the prior placement.  (I will take a meaure or calc column solutio...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    5 years ago

    Hi,

    This calculated column formula works

    =CALCULATE(MIN(Data[dateBegin]),FILTER(Data,Data[candidateID]=EARLIER(Data[candidateID])&&Data[dateBegin]>EARLIER(Data[dateBegin])))

    Hope this helps.

Fro88er's avatar
Fro88er
Icon for Helper IV rankHelper IV
5 years ago

Thank you so much!  You made my weekend. 

 

Kind regards,

Mark

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
5 years ago

You are welcome.