Forum Discussion

josy0244's avatar
josy0244
New Member
3 years ago
Solved

DATEDIFF Function: Error between two dates

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: ...
Need Help
  • o0llied's avatar
    o0llied
    3 years ago

    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!

o0llied's avatar
o0llied
Frequent Visitor
3 years ago

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!