Fast Running Totals in Power Query (Complete Guide)

Fast Running Totals in Power Query (Complete Guide)

36.352 Lượt nghe
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/running-total/ 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_confirmation=1 LET'S CONNECT: Blog: https://gorilla.bi Facebook: https://facebook.com/BIGorilla/ Twitter: https://twitter.com/rickmaurinus LinkedIn: https://linkedin.com/in/rickmaurinus/ Thank you for your support! #RunningTotal #powerquery #bigorilla