Average Last 3 Customer Sales: Power Query, DAX Measure or Worksheet Formula: Excel Magic Trick 1552

About this tutorial: Video duration: 22:45 Download Excel Finished Files: Entire page with all Excel Files for All Videos: In this video learn how to Average a customers last three sales (last three dates) using Excel Worksheet Formulas, Power Query M Code and a Power Pivot & Power BI DAX Measure. Learn about the Table.Sort […]

Excel Magic Trick 1378: Average of Customer Total Sales by Product: Formulas, DAX or Array Formula?

About this tutorial: Video duration: 29:29 Download File: 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 […]

Excel Magic Trick 1322: Backwards One To Many Relationship Report: Excel, Power Query or SQL?

About this tutorial: Video duration: 30:37 Download File: See how to use Excel, DAX, Power Query or SQL to Calculate Average GPA with one condition when the formulas need to ework backwards across a One To Many Relationship between Two Tables: 1. (00:16) Problem Introduction 2. (03:17) Excel Array Formula Solution using AVERAGE, IF and […]