Download the Problem3.xlsx  file.  Copy the file to the C:/D…

Questions

Dоwnlоаd the Prоblem3.xlsx  file.  Copy the file to the C:/Dаtа folder. (If using the VDI environment, copy the file to the Desktop) The file contains a pivot table of units and sales data for a company.  Load the Problem3.xlsx file into a new workbook, get the data from the table/range "Units-Sales" worksheet, and create a Power Query that will do the following: 1. Convert the Pivot Table data into a Fact table. (Hint: When getting the table/range data, uncheck the box "my table has headers.") 2. Place the "Month" and "Region" columns as the first two columns and rename the attribute column to "Units/Sales". 3. Name the query Units-Sales Fact. Load the result of the query into a new worksheet in the workbook.  A correct query will result in a worksheet similar to the image shown below.  Save the Workbook with the Power Query as "Problem3-clean.xlsx" and upload it to this question.