Videos about Excel Microsoft Power BI Desktop from Mike excelisfun Girvin at Highline College.
Curated by: excelisfun (61 videos)
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.