You’re offline. This is a read only version of the page.
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.
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.
Share
Report
All responses (
Answers (
610
