Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

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

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"?

manap_0-1620064760721.png

 

1 ACCEPTED SOLUTION
DataInsights
Super User
Super User

@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/ 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

1 REPLY 1
DataInsights
Super User
Super User

@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/ 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.