Question:
You have an Excel spreadsheet that contains three columns labeled Year, 2021, and 2012. The entries in rows for the first column consists of names of the individual months in the year while the other two columns contain the sales amount for each month for the corresponding year. You import data from the Excel spreadsheet into Power BI Desktop. You need to transform the data so it will consist of three columns, with the first one containing month, the second containing year, and the third containing the sales amount for that month and year. Which transformation should you use first?Select only one answer. Pivot Remove Columns Transpose Table Unpivot
Author: da-biAnswer:
Unpivot This answer is correct.
0 / 5 Â (0 ratings)
1 answer(s) in total