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
Leave a Reply
You must be logged in to post a comment.