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 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. 

 

DATEDIFF
Need Help DAX

5 Replies

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

    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.

     

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

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

      • 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.