topic Re: Date Diff between Created Date and Closing Date in DAX Commands and Tips

Date Diff between Created Date and Closing Date

Alicia83B — Mon, 19 Sep 2022 16:37:34 GMT

I am trying to calculate the length of time between an opportunity created date and closing date. I am using the below measure, but I get an error "Too few arguments were passed to the DATEDIFF function. The minimum argument count for the function is 3. I have never used this function before and have followed what I have seen in other formum examples with no resolution. Can someone direct me on how to correct the error?

Time to Close (Days) = DATEDIFF(MIN(Opportunities[createdtime]), MAX(Opportunities[closingdate], DAY))

Thank you in advance for looking at my post.

Re: Date Diff between Created Date and Closing Date

Greg_Deckler — Mon, 19 Sep 2022 16:41:24 GMT

Alicia83B Try:

Time to Close (Days) = ( MAX(Opportunities[closingdate]) - MIN(Opportunities[createdtime]) ) * 1.

Also, you are missing a ) right before ", DAY" and so then have an extra ) at the end.

Re: Date Diff between Created Date and Closing Date

Alicia83B — Mon, 19 Sep 2022 16:47:59 GMT

Greg_Deckler Hi Greg, thanks for the reply. This did not work. I have a red swiggly line under the ) before *1

Re: Date Diff between Created Date and Closing Date

Greg_Deckler — Mon, 19 Sep 2022 16:54:05 GMT

Alicia83B Did you miss the leading ( ? Also, probably need single quotes around your table names:

Time to Close (Days) = ( MAX('Opportunities'[closingdate]) - MIN('Opportunities'[createdtime]) ) * 1.

Re: Date Diff between Created Date and Closing Date

Alicia83B — Mon, 19 Sep 2022 16:59:49 GMT

Greg_Deckler Below is what I have for the measure. Still not working.

Time to Close (Days) = DATEDIFF( (MAX('Opportunities'[closingdate]) - MIN('Opportunities'[createdtime]) ) * 1)

Re: Date Diff between Created Date and Closing Date

Greg_Deckler — Mon, 19 Sep 2022 17:57:53 GMT

Alicia83B No, forget about the DATEDIFF, you don't need it, use the actual formula I provided. It is a 100% complete formula. Dates are decimal numbers where the integer portion is the number of days since 12/30/1899. So all you have to do is subtract them and multiply by 1. to make sure you return a number instead of a date.