Microsoft Power BI Data Analyst PL-300 Question # 60 Topic 7 Discussion

Microsoft Power BI Data Analyst PL-300 Question # 60 Topic 7 Discussion

PL-300 Exam Topic 7 Question 60 Discussion:
Question #: 60
Topic #: 7

You have the CSV file shown in the following table.

PL-300 Question 60

You use Power Query Editor to preview the data in the file.

You need to transform the data to meet the following requirements:

• The first column must contain the month.

• The second column must contain the year.

• The third column must contain the order amount for the month and year.

Which transformation should you use first?


A.

unpivot


B.

pivot


C.

transpose


D.

remove


Get Premium PL-300 Questions

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.