You use Power Query Editor to preview a query that contains sales order data in the following columns:
• Tax Amount
• Sales Order ID
• Freight Amount
• Subtotal Amount
• Total Item Quantity The Sales Order ID column uniquely identifies each sales order. The Subtotal Amount and Total Item Quantity columns are always populated, but the Tax Amount and Freight Amount columns are sometimes null when an order has no associated amount. You need to query the data to identify the following metrics by month:
• The average item quantity per order
• The average freight amount per order
• The maximum item quantity per order How should you modify the query?
Select one answer.
Purchase Full Access to view answer options & explanation
The first 134 questions in this bank are completely free. Unlock Full Access on the exam page to view all answer choices, verified answers, explanations, and community discussions for all 444 questions.
