Input –

I want to derive a column based on below steps –

1. Check for same ServiceId and Name but Ref is different.
2. If so, then calculate day diff like below –

(take ActualEndTime from 1st row and CreatedDate from 2nd row if ServiceId and Name are matched for diff Ref)

3. Then derive a column ‘Flag’ based on DayDiff calculated in step 2.
   If DayDiff is greater than 30, then Flag should be 0 else 1

(take ActualEndTime from 1st row and CreatedDate from 2nd row if ServiceId and Name are matched for diff Ref)