DAX practice: Navigating Relationships with RELATED
Chapter 4 · 4 questions · included in full access
Question 1 · easy
Unit cost from Products
Solve it in your browserAdd a calculated column Unit Cost to Sales, fetching UnitCost from the Products table.
Question 2 · medium
Unit margin
Solve it in your browserAdd a calculated column Unit Margin to Sales: UnitPrice minus RELATED UnitCost from Products.
Question 3 · easy
Total sales
Solve it in your browserWrite a measure Total Sales that sums the Line Total column.
Question 4 · medium
Profit from measures
Solve it in your browserWrite Profit: [Total Sales] minus [Total Cost]. Both measures already exist.
These questions are part of full access.
The first chapters of every track are free. Full access is a one-time payment.
See pricing