Exam PL-300 topic 2 question 75 discussion

It's the classic definition of unpivot

Upvote this comment so all your exam questions will be like this 🙌🙏

unpivoting 2020 and 2021 columns wouls result in two columns "attribute" (to be renamed as "Year") and "Measure" (to be renamed as "Sales")

We need to unpivot columns and rename them

Sales numbers are pivoted in 2 "year" columns. Just need to unpivot these columns, then rename atribute and value columns to something like "Year" and "Total Sales".

C Correct

C is correct. To shape the query to display the required three columns (month, sales,year), you should select the "Unpivot columns" option in Power Query Editor. This will transfer the data from its current columnar structure (where each year is a separate column) into a tabular format with separate rows for each combination of Month, Sales, and Year.

Tested

Wouldn't it be transpose? Transpose rows 2020 and 2021 and rename new column to Revenue?

C is correct assuming we are selecting the "2020" and "2021" columns