
Ultimate access to all questions.
Consider a scenario where you need to connect to and query datasets using the XMLA endpoint in Fabric. You have a tabular model with a table named 'Sales' that contains columns 'SaleID', 'ProductID', 'CustomerID', 'SaleDate', and 'Amount'. Write a DAX query to find the total sales amount for each product in the last quarter. How would you structure this query?
A
EVALUATE SUMMARIZECOLUMNS('Sales'[ProductID], "TotalAmount", SUM('Sales'[Amount]))
B
EVALUATE SUMMARIZECOLUMNS('Sales'[ProductID], "TotalAmount", CALCULATE(SUM('Sales'[Amount]), 'Sales'[SaleDate] >= DATEADD(QUARTER, -1, TODAY())))
C
EVALUATE SUMMARIZECOLUMNS('Sales'[ProductID], "TotalAmount", CALCULATE(SUM('Sales'[Amount]), 'Sales'[SaleDate] >= DATEADD(QUARTER, -1, NOW())))
D
EVALUATE SUMMARIZECOLUMNS('Sales'[ProductID], "TotalAmount", SUM('Sales'[Amount]))