Need help with date diff

[Shackwell]

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.

[Pragati11 · Accepted solution]

Hi @Shackwell ,

Try something like this:

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

Thanks,

Pragati