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?

QuestionsCategory: PL-300You 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?
Admin Staff asked 7 months ago
You have the CSV file shown in the following table.
 Image
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

Next Post

Recommended

Welcome Back!

Login to your account below

Create New Account!

Fill the forms below to register

Retrieve your password

Please enter your username or email address to reset your password.