Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Multiple IDs in a relationship

Hello,   I have a lot of data in Excel (as source files) and need to create some relationships between the two, however it's not that straight forward;   Table 1 List of roles 1 role to many n...
Need Help
  • danextian's avatar
    danextian
    4 years ago

    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.

tamerj1's avatar
tamerj1
Community Champion
4 years ago

Hi Anonymous 
In order to be able to build a relationship you need to new create a calculated table out of table1 increasing the number of rows by duplicating them in order to have one row for each name and skill. Most probably this would generate a huge table with a very large number of rows most of them are redundant. 
Yet you can still build your pivot table following other methods but you need to share some sample data along with the expected results in order to be able to support you further.  Thank you.