When creating a calculated column in the Sales table, you need to get the ProductCost from the Products table. Which function should you use?

Question

Answer

A function behavior that would be correct only if filter context were removed, which is not the condition defined in this question

Answer

RELATED(Products[ProductCost])

Answer

Products[ProductCost], however, this wording confuses row context, filter context, or evaluation timing and therefore misses the exact DAX behavior being tested.

Answer

LOOKUP(Products[ProductCost]), although it sounds technically credible, it does not align with how DAX functions propagate context in this scenario.

Answer

CALCULATE(Products[ProductCost]), although it sounds technically credible, it does not align with how DAX functions propagate context in this scenario.

Crowdly

When creating a calculated column in the Sales table, you need to get the Pro...

Want instant access to all verified answers on learning.devinci.fr?