اختبار شهادة مايكروسوفت Microsoft Power BI Data Analyst

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

Each Customer ID represents a unique customer in the Customer table. Each Address ID represents a unique address in the Address table.

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?