Download files for videos: https://excelisfun.net/files/FilesUsedInVideo31.zip
Class web site with individual file downloads: https://people.highline.edu/mgirvin/AllClasses/348/348/BI348BothClasses.htm
pdf notes for Video: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/DAX/031-MSPTDA-FasterAverages.pdf

In this video learn about how to create different types of DAX average formulas and then time them using DAX Studio.
Topics:
1. (00:15) Introduction
2. (00:38) Open Power BI Desktop File and create Matrix
3. (02:37) Create First Two DAX Average Formulas
4. (06:20) Parallel Excel Worksheet example to understand the DAX averages and what happens if there is a Blank or empty cell.
5. (7:52) DAX Studio to time formulas.
6. (12:44) Look at four other DAX average formulas and timing results.
7. (14:36 ) Conclusion
Comprehensive Microsoft Power Tools for Data Analysis Class, BI 348, taught by Mike Girvin, Excel MVP and Highline College Professor.