You have the CSV file shown in the following table.
 
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. remove

B. unpivot

C. transpose

D. pivot








 

Suggested Answer: B



This question is in PL-300 Exam
For getting Microsoft Power BI Data Analyst Associate Certificate