You import the data from two next files into a PowerPivot model to create two tables named Customers and Invoices. Each table contains a column named CustomerID. When you attempt to create a relationship between the Customers table and the Invoices table by using the CustomerID column from each table, the relationship cannot be created due to duplicate CustomerID values. You need to ensure that you can create the relationship. What should you do?

Question

Accepted Answer

C. Group the Customers query by CustomerID

Answer

A. Add an index column to the Customers query

Answer

B. Add an index column to the Invoices query

Answer

D. Sort the Invoices query by CustomerID, and then add a Fill Down step

You import the data from two next files into a PowerPivot model to create two tables named Customers and Invoices. Each table contains a column named CustomerID. When you attempt to create a…

Question

Options

How the community answered

Community Discussion