Forum Discussion
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...
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.
Hi Anonymous ,
Whether the advice given by danextian has solved your confusion, if the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out.
Looking forward to your feedback.
Best Regards,
Henry