Power Query Excel | M CODE - Challenge Solutions with Table.Partition & List.Accumulate

Описание: There are a number of challenges available out there for people who are keen to practice their excel and power query. I will share more in future videos.

This video is to use the challenge to demonstrate the table.partitioni function. Also, brieft cover my best solution for the challenge.

Topic:
0:22- Intro
First Solution:
1:23 - Table.Partition
3:05 - List.Accumulate

Best Solution (Personal):
5:07 - Personal best solution with List.Accumulate

Topic useful to understand some of the functions in the video:
List.Accumulate -    • Power Query (Excel) + M Code | List.Accumu...  

Workbook:
https://docs.google.com/spreadsheets/...

Challenge Link:
https://www.linkedin.com/posts/aditya...