Go Multi-Level

Chain JOINs with filters and grouping logic.

Now we’ll level up! You’ll combine joins, grouping, and filtering into Power Queries, the kind you’d use in real dashboards and apps.

Goal

You’ll aim to:

  • Join tables.

  • Group data by category.

  • Filter grouped results.

Tables

Use the same students and grades tables:

The students table