Exam DP-600 topic 1 question 102 discussion

Should be CALCULATE, not SUMMARIZE

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.

I dissagree with the second answer. It says that "You need to write a DAX query that will be executed by using the XMLA endpoint." Therefore...it uses EVALUATE, so it can return a Table. A 1 Row and 1 Column table, but a Table (because the external tool requires it) Therefore it should be { _LYSales }

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

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

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}

EVALUATE VAR _LYSales = CALCULATE ( [Total Sales], SAMEPERIODLASTYEAR ( 'Orders'[Order Date] ) ) RETURN _LYSales

Calculate & _ LY

CALCULATE, _LYSales

CALCULATE & _LYSales