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
Watch video 68 - Creating a cumulative sum column in Power Query online without registration, duration hours minute second in high quality. This video was added by user WesleySon 01 May 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 114 once and liked it 1 people.