Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Datediff using a specific ID

I'm trying to use the completed date of action "C1001A" to find out the age of the subsiquent actions in days.  I think the formula I'm using is filtering everything except "C1001A" out though.    ...
DATEDIFF
Filter
  • Greg_Deckler's avatar
    Greg_Deckler
    4 years ago

    Anonymous Maybe:

    Holding stage age  =
VAR startdate = MAXX(FILTER('hgmcntac', hgmcntac[action_cd] = "C1001A"), hgmcntac[completed_dt])
RETURN
 (TODAY() - startdate) * 1.
Greg_Deckler's avatar
Greg_Deckler
Community Champion
4 years ago

Anonymous Maybe:

Holding stage age  =
VAR startdate = MAXX(FILTER('hgmcntac', hgmcntac[action_cd] = "C1001A"), hgmcntac[completed_dt])
RETURN
 (TODAY() - startdate) * 1.
  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Greg_Deckler  Thank you very much