Forum Discussion
Helper IDate Diff between Created Date and Closing Date
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?
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.
5 Replies
- Greg_Deckler
Community Champion
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.
Alicia83BGreg_Deckler Hi Greg, thanks for the reply. This did not work. I have a red swiggly line under the ) before *1
- Greg_Deckler
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.