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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Related on 2 columns

I have two tables:
 Fisrt:

idcodevalue
56786_1first_value
56786_2second_value
56786_3third_value
56786_4forth_value
56786_5fifth_value
56786_6sixth_value


Second:

id

codevalue
56786_3 third_value
35678_4forth_value
55567_1first_value


So, in first we apply 6 kinds of values per each person. But in second we got one chosen by person value per that person. How can I add any column from first table to second? Related on person_id and code.
It can be complicated, so, if smth is unclear, ask me please, because I find it hard to do it. Thank you!

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @Anonymous ,
you can concatenate both id and code columns and have both the tables related on that composite key. Then use RELATED() to add any column from the first table to the second.

Regards,
Aditya

View solution in original post

1 REPLY 1
Anonymous
Not applicable

Hi @Anonymous ,
you can concatenate both id and code columns and have both the tables related on that composite key. Then use RELATED() to add any column from the first table to the second.

Regards,
Aditya

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.