Fast Running Totals in Power Query (Complete Guide)
Running totals in Power Query can be fast, if you know how. This video shows different methods and analyzes why some perform better than others.
WRITTEN ARTICLE:
https://gorilla.bi/power-query/runnin...
Master Functions and Syntax in M
https://powerquery.how
ABOUT BI Gorilla:
BI Gorilla shares videos and articles on Power BI and Excel to help you improve your skills.
CONTENTS
00:00 Introduction
01:27 List.FirstN
05:02 List.Range
06:06 Performance Problems
10:47 List.Generate
17:33 Combine Running Total with Table
23:41 List.Accumulate
Website: https://gorilla.bi
SUBSCRIBE TO MY CHANNEL
https://youtube.com/bigorilla?sub_con...
LET'S CONNECT:
Blog: https://gorilla.bi
Facebook: / bigorilla
Twitter: / rickmaurinus
LinkedIn: / rickmaurinus
Thank you for your support!
#RunningTotal #powerquery #bigorilla