BenchMark Quizzes by MDFT Pro

Create Sales By Shipping Date Measure In Power BI

You have an Orders table at MDFT Pro with OrderDate and ShippingDate columns. The academy wants to analyze sales by the date products are shipped, not just when they are ordered.

You have the following DAX expression:

Sales By Shipping Date :=
CALCULATE(
    SUM(Orders[SalesAmount]),
    ________ ('Date'[Date], Orders[ShippingDate])
)

You need to complete the DAX expression by filling in the missing text. What should you add?

Choose the correct answer from the options below.

Explanations for each answer:

EVALUATE is incorrect. EVALUATE is used in DAX queries to return a result set, not for defining measures or activating relationships in calculations. It is not applicable in this context.
FILTER is incorrect. FILTER returns a table that represents a subset of another table or expression, based on a filter expression. It is not used to activate relationships between tables.
USERELATIONSHIP is correct. USERELATIONSHIP activates the inactive relationship for Shipping Date in the calculation.
CALENDAR is incorrect. CALENDAR is used to create a date table, which is not relevant for this calculation.
RELATED is incorrect. RELATED uses the active relationship and returns a value from the related table. It doesn't change the active relationship.

Learn more about USERELATIONSHIP in Power BI:

Power BI USERELATIONSHIP

Exam Preparation Quiz

Create Sales By Shipping Date Measure In Power BI