Coursera Plus Annual is 40% Off — Ends June 29.

Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Backwards One to Many Relationship Report - Excel, Power Query or SQL?

ExcelIsFun via YouTube

Start learning Write review
TrainSec Ad

Learn EDR Internals: Research & Development From The Masters

Learn More → Coursera Ad

Learn AI, Data Science & Business — Earn Certificates That Get You Hired

Learn More →

Overview

AI, Data Science & Cloud Certificates from Google, IBM & Meta — 40% Off
One plan covers every Professional Certificate on Coursera. 40% off Coursera Plus Annual.
Unlock All Certificates
Learn advanced Excel techniques for calculating average GPA with one condition across a one-to-many relationship between two tables. Explore multiple solutions using Excel array formulas, DAX measures in Excel 2016 Data Model, Power Query, and SQL coding in Access. Master the use of functions like AVERAGE, IF, COUNTIFS, AVERAGEX, CALCULATE, and FILTER to solve complex data analysis problems efficiently.

Syllabus

) Problem Introduction.
) Excel Array Formula Solution using AVERAGE, IF and COUNTIFS function with a Function Argument Array Operation.
) Excel 2016 Data Model DAX formula (DAX Measure) solution using AVERAGE, AVERAGEX, CALCULATE and FILTER functions, without Power Pivot.
) Power Query (Get & Transform).
) SQL coding in Access.
) Summary.

Taught by

ExcelIsFun

Reviews

Start your review of Backwards One to Many Relationship Report - Excel, Power Query or SQL?

Start learning

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.