Running Total in Power Query - Maven Pizza Table Utilisation
5.2 هزار بار بازدید -
2 سال پیش
-
This video presents an walkthrough
This video presents an walkthrough of creating a running total in Power Query, using the Maven pizza challenge dataset as a sample.
I walkthrough my outline concept and assumptions, before moving through each individual step, and using M code functions such as List.Buffer , List.Sum and List.FirstN.
A big shout out to Rick de Groot for his video on running totals which I used as a basis for some of my calcs:
Creating a Running Total in Power Query
Please leave any comments you may have, or any suggestions for more efficient ways to execute.
Subscribe at: @dganalysis
Blog: https://dg-analysis.com
Twitter: Twitter: DGAnalysis
I walkthrough my outline concept and assumptions, before moving through each individual step, and using M code functions such as List.Buffer , List.Sum and List.FirstN.
A big shout out to Rick de Groot for his video on running totals which I used as a basis for some of my calcs:
Creating a Running Total in Power Query
Please leave any comments you may have, or any suggestions for more efficient ways to execute.
Subscribe at: @dganalysis
Blog: https://dg-analysis.com
Twitter: Twitter: DGAnalysis
2 سال پیش
در تاریخ 1401/07/23 منتشر شده
است.
5,252
بـار بازدید شده