Conditional Running Total and Count Using Power Query | Incredible Solution by
Few days back I hosted a challenge on LinkedIn in which we have to do Conditional Running Total forming Groups of Numbers whose Sum is less than or equal to 10,000. Also, Count the numbers present in a group and present them adjacent to the last number in the group.
@MatthiasFriedmann took up the challenge and came up with an Incredible Solution only using List.Generate. In his video you shall also get to learn about using Custom Function, try...otherwise statement, if...else statement and so much more.
Do follow him on LinkedIn ( / matthiasfriedmann ) and Subscribe to his YouTube Channel ( / @matthiasfriedmann ) for more Amazing Power Query Content.
Link of Original Challenge - https://www.linkedin.com/posts/bhavya...
Link of Solution by @MatthiasFriedmann (with M-Code of Solution) - https://www.linkedin.com/posts/matthi...
