DRAG DROP - You are preparing a financial report in Power BI. You connect to the data stored in a Microsoft Excel spreadsheet by using Power Query Editor as shown in the following exhibit. You need to prepare the data to support the following: ✑ Visualizations that include all measures in the data over time ✑ Year-over-year calculations for all the measures Which four actions should you perform in sequence?...

Questions › Category: PL-300 › DRAG DROP – You are preparing a financial report in Power BI. You connect to the data stored in a Microsoft Excel spreadsheet by using Power Query Editor as shown in the following exhibit. You need to prepare the data to support the following: ✑ Visualizations that include all measures in the data over time ✑ Year-over-year calculations for all the measures Which four actions should you perform in sequence?…

0 Vote Up Vote Down

Admin Staff asked 7 months ago

DRAG DROP -
You are preparing a financial report in Power BI.
You connect to the data stored in a Microsoft Excel spreadsheet by using Power Query Editor as shown in the following exhibit.
 
You need to prepare the data to support the following:
✑ Visualizations that include all measures in the data over time
✑ Year-over-year calculations for all the measures
Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Select and Place:
 
















 

Suggested Answer: 
    

Reference:
https://docs.microsoft.com/en-us/power-query/unpivot-column

This question is in PL-300 Exam
For getting Microsoft Power BI Data Analyst Associate Certificate