topic Re: Calculate Days between Max Date and Second Date in DAX Commands and Tips

Calculate Days between Max Date and Second Date

Anonymous — Thu, 11 Jan 2024 16:34:17 GMT

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!

Re: Calculate Days between Max Date and Second Date

Dangar332 — Thu, 11 Jan 2024 17:45:55 GMT

hi, Anonymous

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

Re: Calculate Days between Max Date and Second Date

Anonymous — Thu, 11 Jan 2024 17:49:54 GMT

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.

Re: Calculate Days between Max Date and Second Date

Dangar332 — Thu, 11 Jan 2024 18:02:19 GMT

hi, Anonymous

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

Re: Calculate Days between Max Date and Second Date

Anonymous — Thu, 11 Jan 2024 18:37:20 GMT

Hi Dangar332

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