Question 247 of 388
Single answerYou are building a Power Bl report that uses data from an Azure SQL database named erp1.You import the following tables. You need to perform the following analyses:- Orders sold over time that include a measure of the total order value- Orders by attributes of products soldThe solution must minimize update times when interacting with visuals in the report.What should you do first?
✓AFrom Power Query, merge the Orders query and the Order Line Items query.
BCalculate the count of orders per product by using a DAX function.
CCreate a calculated column that adds a list of product categories to the Orders table by using a DAX function.
DFrom Power Query, merge the Order Line Items query and the Products query.
✓
Correct Answer: A
From Power Query, merge the Orders query and the Order Line Items query.
▥
Explanation
The correct answer is highlighted above. Review the wording carefully, then use the next question to continue building your understanding of Microsoft certification topics.