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 'Inventory' that contains columns 'ItemID', 'ItemName', 'StockDate', and 'Quantity'. Write a DAX query to find the total quantity of each item in the last quarter. How would you structure this query?