Power BI Data Analyst (PL-300) · Free practice question 5 of 12
RELATED in calculated column
In the Sales table, which sits on the many side of a relationship to Product, the analyst needs a calculated column with each product's standard cost so it can be multiplied by quantity row by row. Which expression should the column use?
- A.RELATEDTABLE('Product')
- B.SUM('Product'[StandardCost])
- C.RELATED('Product'[StandardCost])
- D.LOOKUPVALUE(Sales[Quantity], 'Product'[StandardCost], 1)
Show answer and explanation
Correct answer: C. RELATED('Product'[StandardCost])
Why: RELATED follows the many-to-one relationship from the current Sales row to its product and returns a single value from the one side. RELATEDTABLE goes the other way and returns a table of related rows. The LOOKUPVALUE expression searches the wrong columns, and SUM returns the total cost of all products on every row.