You 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…

Question

Exhibit

Options

• 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
• DFrom Power Query, merge the Order Line Items query and the Products query.

• A
  73% (37)
• B
  8% (4)
• C
  4% (2)
• D
  16% (8)

Explanation

To analyze 'orders sold over time with total order value,' the Orders table must be combined with Order Line Items (which holds the individual line prices/quantities). Merging these two queries in Power Query produces a single flat table, eliminating a relationship and the join overhead Power BI must process at render time, thereby minimizing visual update time. This is the logical first step because the resulting merged table can then be extended with product attributes in a subsequent step if needed. Option D (merging Order Line Items with Products) addresses the product-attribute analysis but not the time-based order value analysis, making it the second step, not the first. Options B and C (DAX calculations or calculated columns) are computed at query time on every visual interaction, which increases rather than minimizes update times.

No community discussion yet for this question.