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