Running Total in Power Query - Maven Pizza Table Utilisation

Описание к видео Running Total in Power Query - Maven Pizza Table Utilisation

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:   / dganalysis  

Комментарии

Информация по комментариям в разработке