Forum Discussion
Get data from next/previous row
Rallmo , Index can help.
One of the way to get diff , say for timestamp
New Column =
var _max = maxx(filter(Table, [TicketID] = earlier([TicketID]) && [timestamp] <earlier( [timestamp]) ), [timestamp])
return
datediff(_max , [timestamp], second)
Power BI DAX- Earlier, I should have known Earlier: https://youtu.be/CVW6YwvHHi8
https://www.youtube.com/watch?v=cN8AO3_vmlY&t=17820sPower Query- Index Column: https://youtu.be/NS4esnCDqVw
Rallmo , Index can help.
One of the way to get diff , say for timestamp
New Column =
var _max = maxx(filter(Table, [TicketID] = earlier([TicketID]) && [timestamp] <earlier( [timestamp]) ), [timestamp])
return
datediff(_max , [timestamp], second)
Power BI DAX- Earlier, I should have known Earlier: https://youtu.be/CVW6YwvHHi8
https://www.youtube.com/watch?v=cN8AO3_vmlY&t=17820s
Power Query- Index Column: https://youtu.be/NS4esnCDqVw
Thanks for your response amitchandak. My post got marked as spam so I forgot to follow up here. I solved it with an index, but I'll for sure try your solution aswell.