Рет қаралды 27,486
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:
gorilla.bi/power-query/runnin...
Master Functions and Syntax in M
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: gorilla.bi
SUBSCRIBE TO MY CHANNEL
kzbin.info?sub_con...
LET'S CONNECT:
Blog: gorilla.bi
Facebook: / bigorilla
Twitter: / rickmaurinus
LinkedIn: / rickmaurinus
Thank you for your support!
#RunningTotal #powerquery #bigorilla