Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Alicia83B
Helper I
Helper I

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. 

 

1 ACCEPTED SOLUTION

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



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

5 REPLIES 5
Greg_Deckler
Community Champion
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.

 



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

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

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



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

@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)

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



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.