Exam DP-600 All Questions

View all questions & answers for the DP-600 exam

Exam DP-600 topic 1 question 18 discussion

Actual exam question from Microsoft's DP-600

Question #: 18
Topic #: 1

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.

Show Suggested Answer

Suggested Answer:

by wojciech_wie at Feb. 17, 2024, 4:17 p.m.

Comments

Submit Cancel

wojciech_wie

Highly Voted 1 year, 3 months ago

1) DEFINE 2) EVALUATE 3) SUMMARIZE

upvoted 73 times

...

seaverick

Highly Voted 9 months ago

I have tested it in dax.do changing fields and ans is DEFINE, EVALUATE and SUMMARIZE: DEFINE VAR _SalesSince = DATE ( 2000, 12, 01 ) EVALUATE FILTER ( SUMMARIZE ( 'Product', 'Product'[Product Name], 'Product'[Available Date] ), 'Product'[Available Date] >= _SalesSince )

upvoted 11 times

...

sajjuh

Most Recent 3 months ago

Table fn doesnt exist?

upvoted 1 times

...

Rakesh16

7 months ago

Define, Evaluate & Summarize

upvoted 2 times

...

Harsha_Guggilla

9 months ago

DEFINE EVALUATE SUMMARIZE

upvoted 2 times

...

user12345678

9 months, 3 weeks ago

Just to save people some time, I haven't seen a function called TABLE, so the last one is SUMMARIZE.

upvoted 3 times

...

6d1de25

11 months, 1 week ago

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

upvoted 4 times

...

Jons123son

11 months, 4 weeks ago

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

upvoted 5 times

...

282b85d

1 year ago

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

upvoted 2 times

...

DarioReymago

1 year ago

Define, Evaluate,Summarize. Option Table does not exist

upvoted 1 times

...

ca63a55

1 year ago

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

upvoted 1 times

...

moooom0000

1 year, 1 month ago

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.

upvoted 1 times

...