68 - Creating a cumulative sum column in Power Query
I show the methods: An easy method that does repeated calculations, and a "calculate once, then do lookups" method.
Also I forgot to wrap my list in List.Buffer!
00:00 List FirstN + List Sum + Index
01:48 Combining into 1 step
02:19 Adding a filter
04:02 Last row
04:12 Threshold + filter in one step
05:12 Unnecessary extra calculations after the threshold (explanation)
06:51 Stop calculations before threshold via List Generate
09:42 Doing a lookup
10:29 Table First N to remove excess rows
10:48 Doing a lookup