Excel Magic Trick 1378: Average of Customer Total Sales by Product: Formulas, DAX or Array Formula? R.Admin 7 years ago Excel Magic Trick 1378: Average of Customer Total Sales by Product: Formulas, DAX or Array Formula? # Share this:Print Excel Magic Trick 1387: Data Model & DAX Formulas: Quantity Frequency Distribution by Year & CountryDateMarch 25, 2017In relation toLearn ExcelExcel Magic Trick 1137: Excel & PowerPivot DAX Formula: Approximate Match Lookup Without VLOOKUPDateMarch 25, 2017In relation toLearn ExcelExcel Magic Trick 1323: DAX Formula to Pass Many-Side Filter to One Side Aggregate CalculationDateMarch 25, 2017In relation toLearn Excel