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.