What should you do?

You import two Microsoft Excel tables named Customer and Address into Power Query.

Customer contains the following columns:

✑ Customer ID

✑ Customer Name

✑ Phone

✑ Email Address

✑ Address ID

Address contains the following columns:

✑ Address ID

✑ Address Line 1

✑ Address Line 2

✑ City

✑ State/Region

✑ Country

✑ Postal Code

The Customer ID and Address ID columns represent unique rows.

You need to create a query that has one row per customer. Each row must contain City, State/Region, and Country for each customer.

What should you do?
A . Merge the Customer and Address tables.
B. Transpose the Customer and Address tables.
C. Group the Customer and Address tables by the Address ID column.
D. Append the Customer and Address tables.

View Answer

Answer: A

Explanation:

There are two primary ways of combining queries: merging and appending.

✑ When you have one or more columns that you’d like to add to another query, you merge the queries.

✑ When you have additional rows of data that you’d like to add to an existing query, you append the query.

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