power query running total help

[martingaleh]

I have a complicated windowed running total I'm trying to calculate. I've made an excel example that I'd like to implement in powerquery so I don' thave to copy the formulas down. Here's an example file
https://file.io/k7yZ4D

 

[martingaleh]

Wow, file.io is a crappy service

so I don't know what are you trying to achieve if that method from link is not acceptable for you

besides hard to say something more if post#1 and 2: