Exam DP-600 topic 1 question 102 discussion

Actual exam question from Microsoft's DP-600

Question #: 102
Topic #: 1

HOTSPOT -

You have a Fabric tenant that contains a semantic model. The model contains data about retail stores.

You need to write a DAX query that will be executed by using the XMLA endpoint. The query must return the total amount of sales from the same period last year.

How should you complete the DAX expression? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Show Suggested Answer

Suggested Answer:

by MM_GG at April 5, 2024, 8:07 a.m.

Comments

Submit Cancel

MM_GG

Highly Voted 1 year, 2 months ago

Should be CALCULATE, not SUMMARIZE

upvoted 58 times

...

554b579

Highly Voted 1 year, 2 months ago

CALCULATE([Total Sales], SAMEPERIODLASTYEAR('Order'[Order Date])) The entire expression calculates the sales amount for the same period last year based on the current date context. The SUMMARIZE function creates a summary table based on grouping and aggregation.

upvoted 14 times

...

97b39d5

Most Recent 3 months ago

CALCULATE & {_LYSales} CALCULATE returns a scalar. EVALUATE can't return a scalar, it needs a table. ROW CONSTRUCT {} transforms a scalar into a table.

upvoted 1 times

...

seaverick

9 months ago

right ans -> CALCULATE I tried in DAX.do with Contoso data and return an error (In query, I have changed [Total Sales] by [Sales Amount] and Orders[Orde Date] by Sales[Order Date]): EVALUATE VAR _LYSales = SUMMARIZE ([Sales Amount],SAMEPERIODLASTYEAR (Sales[Order Date])) RETURN _LYSales Error: Query (2, 42) Function SUMMARIZE expects a column name as argument number 2. Technical Details: RootActivityId: 435f1c64-89c5-4587-9d79-187541b1e1e3 Date (UTC): 9/15/2024 8:04:33 AM

upvoted 6 times

...

Lucetmi

12 months ago

Be careful, EVALUATE in DAX queries always returns the result of a table expression, then _LYSales is a wrong answer (scalar value). The correct answers are then: CALCULATE, {_LYSales}

upvoted 10 times