Running Total in Power Query - Maven Pizza Table Utilisation

Gerard Duggan
Gerard Duggan
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
2 سال پیش در تاریخ 1401/07/23 منتشر شده است.
5,252 بـار بازدید شده
... بیشتر