Download File: https://people.highline.edu/mgirvin/excelisfun.htm
See how to create a DAX Measures for Moving 12 Month Average on Daily Sales:
1. (00:15) Introduction and comparison to formulas created in Excel Magic Trick 1406.
2. (01:07) Discussion of Filter Context and how we must change it to get the DAX Formula to look 12 months backwards
3. (02:00) Look at Two Tables, Data Model and Relationships that have already been created.
4. (03:00) DAX Measure for Moving 12 Month Average on Daily Sales. See the DAX Functions: AVERAGE, CALCULATE, DATESINPERIOD, LASTDATE, MAX, MIN, IF, AND, and ALL.
5. (12:25) How to use DAX Formatter to format long DAX Code. This amazing web site from Marco Russo and Alberto Ferarri will automatically format your DAX Formula. Web address.
6. (13:48) Summary