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

You import a Microsoft Excel spreadsheet into Power Query Editor and name the query Sales_Spreadsheet.

Sales_Spreadsheet contains the following columns:

Customer ID
Customer Name
Date
Total Sales Amount

You plan to use the Sales_Spreadsheet query to load two tables named Customer and Sales into the associated semantic model. The tables relate to each other on the Customer ID column of each query. The solution must meet the following requirements:

The Customer query must contain the Customer ID and Customer Name columns.
The Sales query must contain the Customer ID, Date, and Total Sales Amount columns.
Power Query logic must be consolidated to avoid the duplication of logic across the queries and ensure that only one location is used to update the logic.

You need to identify how to create the Sales query, and what to do to the Sales_Spreadsheet query before loading the model.

What should you do?