Thank you Sensei! Another great video on List.Accumulate. I have used this function in several real-world queries since you recently demonstrated its power and flexibility.
Great video, but wish you had posted the M Code or put it in a Note in the file. It took me an HOUR to finally see I had state & {" " & CurrentChar} instead of state & {" ", CurrentChar}! 🤪🤪 Would love to see a video on converting this to a function!
Thank you. Your teachings always open up a lot of new knowledge, how and what can be done. Also, I have a question. Does the file on github also have the code. There is no way I can see it.
Thanks for the video.l I hated List.Accumulate the first few times I had to use it, kI couldn't get my head around the idea of iteration without some kind of for statement, my brain refused completely to process how the function could possibly keep count of hte number of iterations completed and after that sank in I had real problems seeing how the loop could end. I still find it makes my head ache writing the functions and debugging them is even worse!
Excellent solution. The List.Accumulate function is not very easy, but is important to know it. Thank for sharing
Thank you Sensei! Another great video on List.Accumulate. I have used this function in several real-world queries since you recently demonstrated its power and flexibility.
Your advanced tips on power query are always always excellent. Thanks James ❤👍
My pleasure!
Bang on, you are an artist man.... Learning in depth about power query from your videos....Keep bringing these awesome videos
thanks man! this is glorious!
Great video, but wish you had posted the M Code or put it in a Note in the file. It took me an HOUR to finally see I had state & {" " & CurrentChar} instead of state & {" ", CurrentChar}! 🤪🤪
Would love to see a video on converting this to a function!
Great video. Your technique is amazing. Thank you
awesome thank you!
wonderful, thank you very much. Greetings
Thank you too!
Thank you. Your teachings always open up a lot of new knowledge, how and what can be done.
Also, I have a question. Does the file on github also have the code. There is no way I can see it.
Yes it does
Thanks for the video.l I hated List.Accumulate the first few times I had to use it, kI couldn't get my head around the idea of iteration without some kind of for statement, my brain refused completely to process how the function could possibly keep count of hte number of iterations completed and after that sank in I had real problems seeing how the loop could end. I still find it makes my head ache writing the functions and debugging them is even worse!
Hey Roy! i also took a while with it! hahah ait's so counter intuitive! not seeing a loop!
@@basensei8699 exactly!
Why exist 2 let and 2 ln in cod e