DRAG DROP – You have a Microsoft Excel workbook that contains two sheets named Sheet1 and Sheet2. Sheet1 contains the following table named Table1. Sheet2 contains the following table named Table2. You need to use Power Query Editor to combine the products from Table1 and Table2 into the following table that has one column containing no duplicate values. Which three actions should you perform in sequence? To answer, move the…

QuestionsCategory: PL-300DRAG DROP – You have a Microsoft Excel workbook that contains two sheets named Sheet1 and Sheet2. Sheet1 contains the following table named Table1. Sheet2 contains the following table named Table2. You need to use Power Query Editor to combine the products from Table1 and Table2 into the following table that has one column containing no duplicate values. Which three actions should you perform in sequence? To answer, move the…
Admin Staff asked 7 months ago
DRAG DROP -
You have a Microsoft Excel workbook that contains two sheets named Sheet1 and Sheet2.
Sheet1 contains the following table named Table1.
 Image
Sheet2 contains the following table named Table2.
 Image
You need to use Power Query Editor to combine the products from Table1 and Table2 into the following table that has one column containing no duplicate values.
 Image
Which three 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:
 Image
















 

Suggested Answer: 
    Correct Answer Image

Reference:
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-shape-and-combine-data

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

Next Post

Recommended

Welcome Back!

Login to your account below

Create New Account!

Fill the forms below to register

Retrieve your password

Please enter your username or email address to reset your password.