Forum Discussion
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: ...
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!
Thank you so much. I used the below formula and it worked.