Identify cycles in records

Hi Syndicate_Admin ,

1. Create a new column to rank the start time with machine group:

Rank = RANKX(FILTER('Table',EARLIER('Table'[machine_id])='Table'[machine_id]),'Table'[mission_start_time],,ASC)

2. Create a measure to calculate the difference :

Diff_1 = 
var current_ =MAX('Table'[Rank])
var last_ = CALCULATE(MAX('Table'[mission_end_time]),FILTER(ALL('Table'),'Table'[Rank]=current_-1))
return DATEDIFF(last_,MAX('Table'[mission_start_time]),MINUTE)

3. Calculate the the cycle time:

Diff_2 = 
var current_ =MAX('Table'[Rank])
var last_ = CALCULATE(MAX('Table'[mission_start_time]),FILTER(ALL('Table'),'Table'[Rank]=current_-1))
return IF([Diff_1]<3&&MAX('Table'[Rank])>1,MAX('Table'[mission_end_time])-last_,BLANK())

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.