Power Query - Looping through Columns

[@PatrickYoung-zy5qc]

When I see a new BA Sensei video, I click!

[@MyAvn]

Showing what South Africans are made off! Well done man, you're a rock star!

[@basensei8699]

glorious thanks man!

[@mnowako]

Excellent! What a great explanation of List.Accumulate! Many thanks!

[@boissierepascal5755]

Mind blowing🤪

[@vaibhavgond]

Thanks for the video James. very helpful.

[@tonybatty504]

Thanks James. I wonder how many times I'm going to have to view the video before list.accumulate sinks in!

[@marklord7614]

and that's what videos are for 🙂

[@basensei8699]

ye this is probably one of the more counter intuitive functions. vs. looping in python.

[@kebincui]

Awesome as always. Thanks James.

[@MrMsmith1]

Great video, ... just a suggestion that you change your RANDBETWEEN formulas to hard coded values (prior to query) so that when we are trying to duplicate your results we can compare and get the same values. I thought I was doing something wrong because my percentage results were not the same as your video; turns out that randbetween was recalculating my values...

[@basensei8699]

oh damn! yes i still had the randbetween on!

[@SamehRSameh]

We need more videos about list.accumlate to train

[@basensei8699]

its one of the more tricky ones but once you get it! it's great!

[@cyclingmc]

Percentage is total for each individual cell or total of each column. So column 1 total is 100 and percentage in each cell is of the total? Right?

[@basensei8699]

correct! the total for each portfolio!