DRAG DROP You have a Microsoft Excel spreadsheet that contains the data shown in the following table (detailed in explanation below): You plan to build a data model for a Power BI report. You need to prepare the data so that it is available to the model in the format shown in the following table (detailed in explanation below): Which three actions should you perform in sequence in Power Query Editor? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Select one answer.
Purchase Full Access to view answer options & explanation
The first 134 questions in this bank are completely free. Unlock Full Access on the exam page to view all answer choices, verified answers, explanations, and community discussions for all 444 questions.
