SEARCH
You are in browse mode. You must login to use MEMORY

   Log in to start


From course:

POWER BI [PI-300]

» Start this Course
(Practice similar questions for free)
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?Select only one answer. Select the Country column and then select Pivot Column. Select the Country column and then select Unpivot Other Columns. Select the first sales data column and then select Unpivot Columns. Select Transpose.

Author: da-bi



Answer:

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


0 / 5  (0 ratings)

1 answer(s) in total

Author

da-bi
da-bi