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