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 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 […]