Answer-first summary for fast verification
Answer: For the TransactionDate column, select Filter rows and set the value to last quarter., For the ProductCategory column, select Group by and sum the SalesAmount column.
The goal is to calculate total sales by product category for the last quarter. Option C ('Filter rows and set the value to last quarter') correctly filters transactions to only those in the last quarter based on the TransactionDate column. Option D ('Group by ProductCategory and sum the SalesAmount column') correctly aggregates the sales amounts by product category to get the total sales per category. Option B ('Keep top rows') is incorrect as it doesn't filter by date range but simply takes the first 90 rows regardless of date. Option A ('Remove duplicates') is irrelevant to filtering by date. Option E ('Add 90 to SalesAmount') is incorrect as it modifies sales values rather than filtering or aggregating.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
You have a Fabric warehouse with a table named Table1. The table contains the columns SalesAmount, ProductCategory, and TransactionDate.
You need to create a Power BI query to calculate the total sales amount for each product category for transactions that occurred in the last quarter.
Which two actions should you perform in the Power Query Editor? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
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.
No comments yet.