Customer table issue

[Anonymous]

Hello, 

Trying to determine the best way to set up a customer table in my data model.   I'm having issues with "many to many" which I don't normally get but I've added an element to the data model.   

Very simply, the issue is that we have customers (distributors) who in turn sell to their customers.   In certain channels, we think of these secondary customers still as "our" customers.    So the customer table can easily look like this: 

Customer ID     Primary Customer    Secondary Customer 

C-0123              Big Inc                       John's Flower Co 

C-0123              Big Inc                       Flower Power Inc 

C-0123              Big Inc                       Plants and More  

Obviously I have duplicates with the Customer ID and the Primary Customer.     How best to create a master customer table (or tables) so that I don't get relationship issues as I try to join them to other tables?     Thanks in advance.  

[v-eachen-msft]

Hi @Anonymous ,

You could use DISTINCT() to create a one-to-many table. 

According to your sample data, even though you have many-to-many relationships you could also get a unique value with multiple columns.

[amitchandak]

@Anonymous 

What does your sales/transaction table have? If it has a Secondary Customer or Secondary Customer ID this should work. else create a customer dimension distinct name and ID. More I can suggest if I have idea how this table is used