Forum Discussion
Managing Relationships
Hello,
I am not able to connect the Program columns below:
And:
I get this message:
Any suggestions?
Thank you!
Hi Anonymous ,
Usually we create a bridge table to create a relationship between two tables:
ProgramTable = DISTINCT( UNION( SELECTCOLUMNS('WES - Scores', "Program", 'WES - Scores'[Program]), SELECTCOLUMNS('Respectful Environment', "Program", 'Respectful Environment'[Program]) ) )Many-to-many relationship guidance - Power BI | Microsoft Learn
Then use the fields in the bridge table.
Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
11 Replies
Hi Anonymous ,
Usually we create a bridge table to create a relationship between two tables:
ProgramTable = DISTINCT( UNION( SELECTCOLUMNS('WES - Scores', "Program", 'WES - Scores'[Program]), SELECTCOLUMNS('Respectful Environment', "Program", 'Respectful Environment'[Program]) ) )Many-to-many relationship guidance - Power BI | Microsoft Learn
Then use the fields in the bridge table.
Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
Can you please explain why you have duplicate rows in the second table?
What is your expected outcome?
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.
Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
