Forum Discussion

Anik's avatar
Anik
Helper I
5 years ago
Solved

Difference between two dates

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 fil...
  • amitchandak's avatar
    amitchandak
    5 years ago

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

     

     

     

     

Anik's avatar
Anik
Helper I
5 years ago

amitchandak , tried but same result, negative difference. 

amitchandak's avatar
amitchandak
Super User
5 years ago

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