Question

In Power Query, you have a transaction table with columns Region, ProductID, and SalesAmount containing 500,000 rows. Your report only needs total sales and the number of transactions per Region. You want to reduce the model size before loading. Which Power Query operation should you use?

Accepted Answer

Use Group By on Region, adding a Sum aggregation of SalesAmount and a Count Rows aggregation

Answer

Use Pivot Column on Region with SalesAmount as the values column

Answer

Use Remove Duplicates on the Region column

Answer

Create a DAX measure with SUMMARIZE after loading all rows into the model