Excel Magic Trick 1378

Average of Customer Total Sales by Product: Formulas, DAX or Array Formula?

DESCRIPTION

See how to calculate Average of Customer Total Sales by Product using Excel Formulas, Excel Array Formulas and DAX Measures in Excel Power Pivot:
(00:15) Introduction
(01:08) 2 Step Solution with SUMIFS and AVERAGEIF functions.
(07:21) 2 SUMIFS Array Formula
(11:26) FREQUENCY Array Formula
(15:20) COUNTIFS Array Formula
(17:40) Time all three Array Formulas to learn which is fastest Calculating
(19:10) Excel 2016 Power Pivot Data Model & DAX Measures
(21:11) DAX Measure using SUM and DISTINCTCOUNT functions
(24:05) DAX Measure using AVERAGEX, CALCULATE & SUM functions
(28:27) Pivot our DAX Formulas and see that they will see the changing Criteria.
(28:50) Summary

WORKBOOKS

Download “Excel Magic Trick 1361-1380” Excel-Magic-Trick-1361-1380.zip – Downloaded 466 times – 14 MB







Be the first to comment

Leave a Reply