Microsoft Fabric Analytics Engineer Associate DP-600
Get started today
Ultimate access to all questions.
Comments
Loading comments...
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.