POWER BI [PI-300]: You have a query that has a column named Country and columns for each month of sales data. The names of the sales data columns use a format of Month Year, for example January 2022. The month columns contain the Sales Amount values for each month.

You need to reshape the table to have all sales amount values in a single column.

A new column should also be added and contain the relevant month year for each row of data.

What should you do from the Power Query Editor?

Question

You have a query that has a column named Country and columns for each month of sales data. The names of the sales data columns use a format of Month Year, for example January 2022. The month columns contain the Sales Amount values for each month.

You need to reshape the table to have all sales amount values in a single column.

A new column should also be added and contain the relevant month year for each row of data.

What should you do from the Power Query Editor?

da-bi · Accepted Answer

Select the Country column and then select Unpivot Other Columns.
This answer is correct.

POWER BI [PI-300]

Select the Country column and then select Unpivot Other Columns. This answer is correct.

Author