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