Power Query practice: Merging Queries & Relational Joins
Chapter 14 · 5 questions · included in full access
Question 1 · medium
Choosing a join kind
Solve it in your browserYou want only the orders whose product exists in the Products table. Which join kind?
Question 2 · medium
Look up the product cost
Solve it in your browserBring each product's Cost from the Products table: Home ▸ Merge Queries on Product (Left Outer), then expand the new column, ticking only Cost (no prefix).
Question 3 · medium
Add the rep's target
Solve it in your browserMerge Orders with Reps on Rep (Left Outer) and expand Target only, without a prefix.
Question 4 · hard
Reps with no orders
Solve it in your browserWhich reps have no orders at all? Starting from Reps, merge with Orders on Rep using Left Anti, then remove the new Orders column.
Question 5 · medium
The join fan-out trap
Solve it in your browserYou merge a 1,000-row Sales fact table with a Products lookup table on ProductID (Left Outer). After expanding, Sales suddenly has 1,050 rows. What caused this row multiplication?
These questions are part of full access.
The first chapters of every track are free. Full access is a one-time payment.
See pricing