Implementing Analytics Solutions Using Microsoft Fabric — Question 188

You have a Fabric warehouse that contains a table named Table1. Table1 contains three columns named SalesAmount, ProductCategory, and TransactionDate.

You need to create a Microsoft Power BI query that will calculate the total sales amount of each product category for transactions that occurred during the last quarter.

Which two actions should you perform in the visual query editor? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

Answer options

• A. For the TransactionDate column, select Remove duplicates.
• B. For the TransactionDate column, select Keep top rows and set Number of rows to 90.
• C. For the TransactionDate column, select Filter rows and set the value to last quarter.
• D. For the ProductCategory column, select Group by and sum the SalesAmount column.
• E. For the SalesAmount column, select Transformation number column - Standard, select Add, and then set the value to 90.

Correct answer: C, D

Explanation

The correct answers are C and D. Option C allows you to filter the transactions to only include those from the last quarter, which is essential for accurate calculations. Option D groups the data by ProductCategory and sums the SalesAmount, which is necessary to obtain the total sales per category. The other options do not contribute to calculating the total sales for the specified time frame or are irrelevant to the task.