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.
LEFT OUTER JOIN, HAVING. Official guide covers this scenario with joins and aggregation. Practice labs help too if this feels tricky, especially on why HAVING goes after GROUP BY. Someone correct me if T-SQL has a newer way but pretty sure that's it.
