topic Difference between two dates in DAX Commands and Tips

Difference between two dates

Anik — Wed, 18 Aug 2021 05:34:44 GMT

Hello good people, now I am reading "Definitive Guide to dax - Alberto Ferrari". The first image shows the the days between delivery dates and order dates. The 2nd image is the practice file done by me and what you can see is the negative differences. I am working with the same data been used in this book but it's not working for me It's been 3 days I am trying everything to get the accurate result, but I failed. I can't understand what the fault is in tha dataset. For your help, I've provided the file to go it over.

https://drive.google.com/file/d/1R43cXcP0Fa1jdgbXVvq6FhMv2HrYvSWp/view?usp=sharing .

Re: Difference between two dates

amitchandak — Wed, 18 Aug 2021 05:57:20 GMT

Anik , have tried datediff

example new column

new column = datediff ([order date], [Delivery Date],day)

Re: Difference between two dates

Anik — Wed, 18 Aug 2021 06:13:35 GMT

amitchandak , tried but same result, negative difference.

Re: Difference between two dates

amitchandak — Wed, 18 Aug 2021 07:02:41 GMT

Anik , I tried this in the file as new column , see all +ive

DaysToDeliver = if(Sales[Order Date]<Sales[Delivery Date], datediff( Sales[Order Date],Sales[Delivery Date] ,day ) ,datediff( Sales[Delivery Date] ,Sales[Order Date],day ))