Forum Discussion

miguelsus2000's avatar
miguelsus2000
Icon for Helper III rankHelper III
4 years ago
Solved

Date difference between dates in different rows

Hi,   I've seen some examples out in the internet, but cannot seem to solve it yet.  I have the following table         Timestamp                User     Location 1      1/22/2022 3:41:00    Use...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    miguelsus2000 , A new column like this can help


    new column =
    var _min = maxx(filter(Table, [user] =earlier([user]) && [Location] = earlier([Location]) && [Timestamp] < earlier([Timestamp])), [Timestamp])
    return
    datediff(_min, [Timestamp], second)

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

miguelsus2000 , A new column like this can help


new column =
var _min = maxx(filter(Table, [user] =earlier([user]) && [Location] = earlier([Location]) && [Timestamp] < earlier([Timestamp])), [Timestamp])
return
datediff(_min, [Timestamp], second)

miguelsus2000's avatar
miguelsus2000
Icon for Helper III rankHelper III
4 years ago

Thank you amitchandak, this one worked for me.