Forum Discussion

Shackwell's avatar
Shackwell
Helper III
4 years ago
Solved

Need help with date diff

Hello,

 

I´ve been trying to use date difference between two columns in a database and Im unable to link them in the measure formula. Whenever I try to input ' the only options available are my other set of measures.

 

Basically what I´m looking to do is to calculate the delay between scheduled date and shipment date.

 

Thank you for your time.

Need Help
  • Pragati11's avatar
    Pragati11
    4 years ago

    Hi Shackwell ,

     

    Try something like this:

    Days Difference = SUMX('yourTable', DATEDIFF('yourTable'[ScheduleDate], 'yourTable'[ShipmentDate], DAY))

     

    Thanks,

    Pragati

1 Reply

  • Pragati11's avatar
    Pragati11
    Super User
    4 years ago

    Hi Shackwell ,

     

    Try something like this:

    Days Difference = SUMX('yourTable', DATEDIFF('yourTable'[ScheduleDate], 'yourTable'[ShipmentDate], DAY))

     

    Thanks,

    Pragati