How to connect one column from table 1 with 2 columns in table2?

[Anonymous]

Hello!

I have "en sitc4 rev4" table that contains unique values of codes in the Code column. On the other hand, I have Sheet1 (6) that contains Product1 and Product2 columns. Both columns contain codes same as in the column CODE of the "en sitc4 rev4" table. In sheet6 I have described the correlation between Product 1 and Product 2. Now I have connected Sheet1 (6)"Product1" with  "en sitc4 rev4""Code" column. From this connection, I can get the name of the product based on the code value. How can I create relation between Sheet1 (6)"Product2" and "en sitc4 rev4""Code" saving relation between Sheet1 (6)"Product1" and "en sitc4 rev4""Code"?

[DataInsights · Accepted solution]

@Anonymous,

Create an inactive relationship between 'Sheet1 (6)'[Product2] and 'en sitc4 rev4'[Code]. You can activate this inactive relationship with USERELATIONSHIP.

https://www.sqlbi.com/articles/using-userelationship-in-dax/