Forum Discussion

Alicia83B's avatar
Alicia83B
Icon for Helper I rankHelper I
3 years ago
Solved

Date 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 func...
DATEDIFF
Need Help DAX
  • Greg_Deckler's avatar
    Greg_Deckler
    3 years ago

    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.

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
3 years ago

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.

Alicia83B's avatar
Alicia83B
Icon for Helper I rankHelper I
3 years ago

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)
  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    3 years ago

    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.