A Key Example to Unlock the Potential of List.Accumulate in Power Query

List.Accumulate is an extremely powerful function in Power Query, watch this video to understand the potential of this List function.
Click here to download the practice file: docs.google.co...
✅ Please see link to videos mentioned in this video:
🎦 The Secret to List.Accumulate in Power Query - • The Secret to List.Acc...
🎦 Power Query Custom Functions - • Power Query Custom Fun...
🎦 Power Query Parameters - Dynamically Change the Output of Your Queries Based on Their Value - • Power Query Parameters...
✅ If you would like to support the channel by buying me a coffee, (it's really quick and easy), please use this link:
☕www.buymeacoff...
✅ For more videos please subscribe:
🔔 / @missmicrosoft
✅ Please also check out my Excel course on Udemy, please use this link:
📖 www.udemy.com/...

[@MissMicrosoft]

Happy New Year everyone! 🎉
A little New Year's favour, will you please give this video a like and subscribe to the channel? This will really help me hit my 2023 goal of 50,000 subscribers! Thank you 🙏 have a great new year!

[@zahoorsarbandi2982]

once again a very nice video with full of explanation. Nightingale voice is appealing and creating curiosity to listen more and more. In every video, Miss Microsoft is trying to give a clear concept of the topic.

[@MissMicrosoft]

Thank you Zahoor really appreciate your support and kind words 😊

[@williamarthur4801]

That was brill, expanded a bit further so to work on any table with a date column;
(mtable as table , datecol as text , dateA as text )=>
let
Custom1 = Table.Column( mtable , datecol),
Custom2 = List.Accumulate( Custom1, 0 , (S,C) =>
if Date.DayOfWeekName(C) = dateA then S + 1 else S )
in
Custom2

[@MissMicrosoft]

This is excellent, thank you!

[@thamilanban]

Thank you

[@MissMicrosoft]

You're welcome :)