topic Re: Datediff using a specific ID in DAX Commands and Tips

Datediff using a specific ID

Anonymous — Thu, 25 Aug 2022 13:08:04 GMT

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.

Holding stage age =

VAR startdate = CALCULATE(MAX(hgmcntac[completed_dt]), hgmcntac[action_cd] = "C1001A")

RETURN

CALCULATE(DATEDIFF(startdate,TODAY(), DAY))

I want to end up with: x number of days since completion of action "C1001A"

Thanks in advance.

Re: Datediff using a specific ID

Greg_Deckler — Thu, 25 Aug 2022 13:31:19 GMT

Anonymous Maybe:

Holding stage age = VAR startdate = MAXX(FILTER('hgmcntac', hgmcntac[action_cd] = "C1001A"), hgmcntac[completed_dt]) RETURN (TODAY() - startdate) * 1.

Re: Datediff using a specific ID

Anonymous — Thu, 25 Aug 2022 13:41:16 GMT

Greg_Deckler Thank you very much