Videos about Excel Microsoft Power BI Desktop from Mike excelisfun Girvin at Highline College.
Curated by: excelisfun (61 videos)
Download Files: Start File: https://excelisfun.net/files/EMT1378Start.xlsx Finish File: https://excelisfun.net/files/EMT1378Finished.xlsx See how to calculate Average of Customer Total Sales by Product using Excel Formulas, Excel Array Formulas and DAX Measures in Excel Power Pivot: 1. (00:15) Introduction 2. (01:08) 2 Step Solution with SUMIFS and AVERAGEIF functions. 3. (07:21) 2 SUMIFS Array Formula 4. (11:26) FREQUENCY Array Formula 5. (15:20) COUNTIFS Array Formula 6. (17:40) Time all three Array Formulas to learn which is fastest Calculating 7. (19:10) Excel 2016 Power Pivot Data Model & DAX Measures 8. (21:11) DAX Measure using SUM and DISTINCTCOUNT functions 9. (24:05) DAX Measure using AVERAGEX, CALCULATE & SUM functions 10. (28:27) Pivot our DAX Formulas and see that they will see the changing Criteria. 11. (28:50) Summary