How to link AR and Sales Table ?

[Paulyeo11]

Hi All

I like to link these 2 table , when i try to link by CUST_ID , I Get multiple relationhip. Hope some one can advise me how to create bridge table ?

[amitchandak]

@Paulyeo11 , file from your another ticket should help

[manikumar34]

@Paulyeo11 , Create a common Customer ID for the bridge table which consists of values from both customer ID's and remove duplicates. 

Regards, 

Manikumar

[amitchandak]

@Paulyeo11 , Join both of them to a common Customer dimension.

https://www.seerinteractive.com/blog/join-many-many-power-bi/