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
Please login or Register to submit your answer