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 oth...
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

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