Calculate Days between Max Date and Second Date

[Anonymous]

I am trying to get the "Lag" days between the MAX "Physical date" and "terms approved date." This is the code I am currently using but it is not working:

Lag = DATEDIFF(CALCULATE(MAX(cr93f_cpsoo[Physical Date]), cr93f_cpsoo[Terms Approved DateTime]),DAY())

Error: Too few arguments were passed to the DAY function. The minimum argument count for the function is 1.

Please advise. Thank you!

[Dangar332]

hi, @Anonymous 

remove () after Day
Lag = DATEDIFF(CALCULATE(MAX(cr93f_cpsoo[Physical Date]), cr93f_cpsoo[Terms Approved DateTime]),DAY )

[Anonymous]

Hi @Dangar332 

When I remove () after Day it gives me this error:

Too few arguments were passed to the DATEDIFF function. The minimum argument count for the function is 3.

[Dangar332 · Accepted solution]

hi, @Anonymous 

Lag = 
DATEDIFF(
        MAX(cr93f_cpsoo[Physical Date]),
        max(cr93f_cpsoo[Terms Approved DateTime]),
        DAY
  )

[Anonymous]

Hi @Dangar332 

It worked! Thank you! What is the best way to present these findings in a visual?