DP-600: Implementing Analytics Solutions Using Microsoft FabricDemo

By Microsoft · Question Mode

QuestionQ57

Implement and manage semantic models

You have a Fabric tenant containing a semantic model with retail-store data. You need to write a DAX query to run by using the XMLA endpoint. The query must return stores that opened since December 1, 2023. Complete the DAX expression. Values may be used once, more than once, or not at all.

Drag & Drop
DEFINE
EVALUATE
FILTER
SUMMARIZE
TABLE


VAR _SalesSince =
    DATE (2023, 12, 01)


FILTER(
    (Store, Store[Name], Store[OpenDate]),
    Store[OpenDate] >= _SalesSince
)
Explanation

DAX queries use DEFINE for query-scoped definitions and EVALUATE to return a table expression. SUMMARIZE constructs the specified store table, which FILTER then limits to stores whose OpenDate is on or after December 1, 2023.

Community Discussion

No comments yet. Be the first to start the discussion!