Forum Discussion
Multiple IDs in a relationship
Hi Anonymous ,
A relationship in Power BI is between the as-is values in a column in one table and those in another column in another table. If you want to have a relationship between {1,2,3,4} in another table, each of these values must be in a row.
It would be easier for us to visualize what you're trying to achieve if you posted a sample data and then explain further from there.
I think I have a solution but not well suited to excel. The best solution I can think of is to have a list of roles (table 1) with IDs, List of candidates (table 2) with IDs, then a third lookup table with Role ID : Candidate ID, one to many each side. The only issue in Excel is maintaining this lookup table with many people working in the sheet which I dont think would be possible. I could do a Power automate of when the sheet is changed scan for changes and update the lookup, or better yet build a power app rather than use excel, but think its a bit overkill for my situation. I think I'll just build and manually maintain the lookup