Question

A source Excel file loaded into Dataflow Gen2 contains one row per product with twelve separate columns named Jan, Feb, Mar, ... Dec, each holding that month's sales amount. Before loading the data into a fact table, you must reshape it so that there is one row per product per month, with a single 'Month' column and a single 'SalesAmount' column. Which Power Query transformation should you apply?

Accepted Answer

Select the twelve month columns and apply Unpivot Columns to create attribute/value pairs

Answer

Select the Product column and apply Pivot Column using SalesAmount as the values

Answer

Apply Group By on Product and aggregate the month columns with Sum

Answer

Apply Transpose to swap rows and columns in the entire table