New measure - minutes between arrival date time and NOW

[Chris-Mc]

hi

I have a direct query where I need to create a measure to find the difference between "adm-date-time" and "Now date time" in minutes

"adm-date-time" is from the diret query and "Now date time" has been created as a measure using NowDateTime = NOW()

I have tried the DATEDIFF function but cannot add the "adm-date-time" to the formula because it is not a measure. 

I have searched through the forums but cant find a solution.  Can anyone assist?

[vicky_ · Accepted solution]

I think you're on the right track already, but you'll need to wrap "adm-date-time" in a SELECTEDVALUE() function. In the end, the formula should look like:
Difference = DATEDIFF(SELECTEDVALUE([adm-date-time]), NOW(), MINUTES)

[Chris-Mc]

thanks Vicky.  Such a simple solution. Much appreciated