Excel Magic Trick 1322

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

DESCRIPTION

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:
(00:16) Problem Introduction
(03:17) Excel Array Formula Solution using AVERAGE, IF and COUNTIFS function with a Function Argument Array Operation
(08:29) Excel 2016 Data Model DAX formula (DAX Measure) solution using AVERAGE, AVERAGEX, CALCULATE and FILTER functions, without Power Pivot
(18:37) Power Query (Get & Transform)
(24:11) SQL coding in Access
(30:04) Summary

WORKBOOKS

Download “Excel Magic Trick 1321-1340” Excel-Magic-Trick-1321-1340.zip – Downloaded 259 times – 98 MB




Be the first to comment

Leave a Reply