Download Excel Files: https://excelisfun.net/files/EMT1725-1726Start.xlsx Download Solution: https://excelisfun.net/files/EMT1725-1726Finished.xlsx
Learn how to calculate Moving Annual Total using Power Query. See multiple user Interface Steps and a Custom M Code Function.
Learn how to calculate Moving Annual Total in Excel worksheet with Power Query using User Interafce and M Code and a Custom Functions. Advanced Power Query Video.
Topics:
1. (00:00) Introduction to task at hand.
2. (00:49) excelisfun intro videos.
3. (01:09) Overview of steps in Query and Advanced M Code.
4. (01:53) (1) Steps to create Crossjoin Between Product and End Of Month.
5. (07:11) (2) Steps to Calculate Month Sales.
6. (07:49) (3) Steps to Merge or Left Outer Join Cross Join Table and Monthly Sales table.
7. (09:44) (4) Steps to create Custom Function.
8. (15:03) Load Table to worksheet.
9. (15:13) Summary, Closing and Video Links

Related Videos:
Moving Annual Total with SUMIFS Function. Excel Magic Trick 1724
Moving Annual Total with Power Query M Code Custom Function. Excel Magic Trick 1725
Moving Annual Total with DAX Measure. Excel Magic Trick 1726.