Conditional Running Total and Count Using Power Query | Incredible Solution by @MatthiasFriedmann

preview_player
Показать описание
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.

Рекомендации по теме
Комментарии
Автор

Thanks for sharing, @BhavyaGupta! And most of all thanks for this great running total showcase for List.Generate. => A great function allowing to address all the challenges together!

MatthiasFriedmann