Microsoft Fabric Analytics Engineer Associate DP-600
Get started today
Ultimate access to all questions.
Given 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 'Orders' that contains columns 'OrderID', 'CustomerID', 'OrderDate', and 'TotalAmount'. Write a DAX query to find the total amount of orders for each customer in the last year. How would you structure this query?
Given 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 'Orders' that contains columns 'OrderID', 'CustomerID', 'OrderDate', and 'TotalAmount'. Write a DAX query to find the total amount of orders for each customer in the last year. How would you structure this query?
Simulated