BenchMark Quizzes by MDFT Pro

Choose Summarize Options For Power BI Columns

You import a Sales table into Power BI at MDFT Pro. The table contains columns for sales amount, order number, and date keys, and is used for various financial analyses.

Which Summarize option should you recommend for aggregating the columns for use in visualizations and calculating totals?

Choose all correct answers from the options below.

Explanations for each answer:

Amount: Sum is correct. Amount is a decimal number, so Sum is the best aggregation to calculate subtotal of sales.
Order Number: Count is correct. Order Number is an integer and unique, so Count is the best aggregation to count the number of orders.
DateKey: None is correct. DateKey is a date/time field; aggregation is not useful for this field.
Amount: Average is incorrect. Average is not suitable for sales analysis, because we usually calculate sales subtotals, not averages.

Learn more about aggregating columns in Power BI:

Power BI Aggregation

Exam Preparation Quiz

Choose Summarize Options For Power BI Columns