Assistance with Recursive / Iterative Calculation in Power Query

(0) Share

Report

Posted on by C3llarDoor

Hello,

I've researched this a bit and came across several examples of List.Accumulate, but am relatively new to Power Query and not quite sure how to implement this. The purpose of the problem is to run calculations to burden costs with indirect rates, if you are familiar with that terminology.

Screenshot 2024-04-05 at 11.22.31 PM.png

My data table looks something like the above. What I would like to do is take a parameter, [C4] as an example with a value of 1, and run it through a function that yields the following:

C4 = 1

C1 = C4 * .35 = .35

C2 = (C4 + C1) * .07 = .0945

C3 = (C4 + C1 + C2) * .12 = .17334

Total = 1 + .35 + .0945 + .17334 = 1.61784

I need to supply [C4] and return 1.61784. I'm sorry if I'm not describing this well. Any help would be appreciated. Thank you very much.