Forum Discussion
Creating relationships between two tables.
Hi
I'm trying to achieve a relationship between 3 tables - customer, quote and contract.
For each customer, I want to report on items from both of the two child tables.
Customer is related to both the quote and contract tables in a straightforward 1 to many case. However the complication is the quote and contract tables also need to be linked, to identify the associated quote for a contract i.e. I'm getting a triangular relationship. But, PowerBI won't let me have two active relationships from the customer table (ambiguity).
Can I do this in PowerBI?
Hi,
to resolve this issue , you can copy your Quote table, stripout all columns except Quote id and description , link this table with customer table. your data model would look like this after the changes. if your table relationships looks different please share table images with related fields.
Cheers!,
ss
8 Replies
garycarters DO the Union of quote table and contract table so that you can identify the quote to contract per customer
Hi,
to resolve this issue , you can copy your Quote table, stripout all columns except Quote id and description , link this table with customer table. your data model would look like this after the changes. if your table relationships looks different please share table images with related fields.
Cheers!,
ss
I'll give it a try.
