Power bi formula

Hi, i'm looking for some help with a formula on my production planning board - i have a due date that is shown on every line the same, i also have a column (w_day)that's days it takes to produce, i'm trying to create a formula that looks at the last operation of the job (wip_order) minus the due_date by W_days (example job 002649/001 last op is 15, due date is 20/2/23, w_day = 1 new date returned would be 19/2/23) then i would like to do it for every other sequance (example sequance 14 would be the previous date 19/2/23 - w_day of 1 = 18/2/23) and so on until it gets to the sequances and workcentre called GETMAT, this is where i would take the previous date, in this case it would be 9/2/23 based on above information and only taking 10 days off all GETMAT 30/1/23 and this date 30/1/23 would show on all GETMAT sequances.

Current Power bi table