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 with DAX using the CALCULATE, SUM, LASTDATE and DATESINPERIOD functions.

Topics:
1. (00:00) Introduction
2. (00:25) Show Data Model
3. (00:48) Build Initial Data Model PivotTable
4. (01:41) Building Moving Annual Total DAX Measure with CALCULATE, LASTDATE and DATESINPERIOD.
5. (04:14) 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.