DATEDIFF Function: Error between two dates

[josy0244]

I am trying to measure how efficient our purchase order process is by getting the difference between the "Date issued to vendor" and "Requested issued date" by the engineer. I am getting the error:

"Too few arguments were passed to the DATEDIFF function. The minimum argument count for the function is 3."

Also, the date parameters are in Spanish instead of English for some reason. Please see below a snip of the table column.

[josy0244]

Thank you so much. I used the below formula and it worked.

[o0llied · Accepted solution]

Hello josy!

You need to define interval after defining the two dates. So it will know what value it should return. 

For example, if you need the difference between the two dates in number of months, add MONTHS:

Day to issue =
DATEDIFF('table'[Date issued to vendor], 'table'[Requiested issued date].[Día], MONTH)

For more info, please see: https://learn.microsoft.com/en-us/dax/datediff-function-dax

If this fixed your issue, please give a thumbs up and mark this response as the solution.

Have a nice day!