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
Yes, post #4 says "or [try this link]" I was hoping for the "either" part not the "or" part as reading that link involves a level of power query mastering in includes creating a udf, passing the same table and other parameters, getting back a number. I presume it self casts to a primitive, hard to tell and then using that number. I don't know if this is all true, but looking at the amount of interest surrounding this topic, I guess this is an esoteric use case that isn't just easily implemented. Could be worse, could have to use a cursor or scala. Actually scala is easier.