Forum Discussion

axk180022's avatar
axk180022
Helper II
4 years ago

Find difference between 2 rows

DateTime SerialId GenHours Difference 9/22/2020 18:04 M3501-118   4789   blank 4/12/2021 18:19 M3501-118   5047   258 5/5/2021 14:28 M3501-118   5047   0 6/17/2021 15:10 M...
Data Protection
Ashish_Mathur's avatar
Ashish_Mathur
Super User
4 years ago

Hi,

This calculated column formula works

Diff = if(isblank(CALCULATE(max(Data[DateTime]),FILTER(Data,Data[SerialId]=EARLIER(Data[SerialId])&&Data[DateTime]<EARLIER(Data[DateTime])))),blank(),abs(Data[GenHours]-lookupvalue(Data[GenHours],Data[DateTime],CALCULATE(max(Data[DateTime]),FILTER(Data,Data[SerialId]=EARLIER(Data[SerialId])&&Data[DateTime]<EARLIER(Data[DateTime]))),Data[SerialId],Data[SerialId])))

Hope this helps.