Examice

Exam DP-600 All QuestionsBrowse all questions from this exam

Question 18

DRAG DROP -

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 a table of stores that have opened since December 1, 2023.

How should you complete the DAX expression? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.

NOTE: Each correct selection is worth one point.

Correct Answer:

Discussion

wojciech_wie

1) DEFINE 2) EVALUATE 3) SUMMARIZE

a_51

The VAR_SalesSince should have a space between them to be: VAR _SalesSince.

Jeff_Zhu

DEFINE EVALUATE SUMMARIZE

Momoanwar

Define - evaluate - summarize

adilene

1) DEFINE 2) EVALUATE 3) SUMMARIZE

282b85d

DEFINE VAR _SalesSince = DATE(2023, 12, 01) EVALUATE FILTER( SUMMARIZE( Store, Store[Name], Store[OpenDate] ), Store[OpenDate] >= _SalesSince )

woliveiras

Define, Evaluate and Summarize. Please, update the correct answer.

6d1de25

The correct syntax is: Define Evaluate Table https://learn.microsoft.com/en-us/dax/define-statement-dax https://learn.microsoft.com/en-us/dax/evaluate-statement-dax

Jons123son

Was in exam. Scored 95% Chose 1) DEFINE 2) EVALUATE 3) SUMMARIZE

DarioReymago

Define, Evaluate,Summarize. Option Table does not exist

ca63a55

Why is it necessary to SUMMARIZE? the stores are supposed to have different names, wouldn't a FILRTER be enough?

moooom0000

https://stackoverflow.com/questions/69047367/table-visual-is-unintuitively-aggregating-my-data Refer to this post. It explains why the don't summarize option is not correct.