Buscar
Estás en modo de exploración. debe iniciar sesión para usar MEMORY

   Inicia sesión para empezar


Por supuesto:

POWER BI [PI-300]

» Iniciar este curso
(Practica preguntas similares gratis)
Pregunta:

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.

Autor: da-bi



Respuesta:

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


0 / 5  (0 calificaciones)

1 answer(s) in total

Autor

da-bi
da-bi