How to avoid many to many relationship ?

[Anonymous]

Hi All

i have AR and SALES table need to link. Now i am link thru CUST_ID , It work fine , but it create many to many relationship. 

I get multiple relationship.

Can some one share with me .

https://www.dropbox.com/s/6ztvt3u4ten6qwa/SALES%20AND%20AR%20VER001.pbix?dl=0

Above is my PBI file

Paul Yeo

Paul

[amitchandak · Accepted solution]

@Anonymous , Please find the attached file after the signature.  I created two common tables

[Anonymous]

Hi Amit

Thank you very much , it is very tricky , the CUST_ID why i must using bridge CUST_ID ? 

Paul

[manikumar34]

@Anonymous , 

If you duplicate values on the relating columns you will get many to many relationship. If you want to make it to one to many then create dimension table or a bridge table with unique values and use to relate with that table. 

Regards, 

Manikumar

[Anonymous]

Hi Mani

i need to create a join key by CUST_ID & COMPANY , and join these 2 table . You have any example

[nvprasad]

HI 

It could be possible that both the tables are having duplicate "Customer ID's. You can create intermediate table of unique "Customer ID's and establish a relationship with both the tables.

Appreciate a Kudos! 🙂
If this helps and resolves the issue, please mark it as a Solution! 🙂

Regards,
N V Durga Prasad