As with many things in Power BI, there are often multiple ways of accomplishing the same thing. Here’s another solution to your issue, this time using DAX and a simple modification of the [Previous Row Value] pattern:
This returns the desired result for [Job ID] 4314879 as per your example, but falls down on others, as there are cases where there are multiple records in your dataset for each job ID-sequence ID combination.
