MSPTDA 31: DAX Studio to Time DAX Average Formulas: AVERAGEX or DISTICTCOUNT? HD

Download files for videos: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/DAX/FilesUsedInVideo31.zip Class web site with individual file downloads: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/DAX/DAX.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.