I have 4 tables proposal, prod, prodModule, addon. All are having 3 columns same like, proposlaId, quotenum, CrId.
ProposalId's can have multiple w.r.t versions.
proposalId | version
proposalId | abc |....
proposalId | def |... .
I want to make relation ship from proposal table to prod with ProposalId (many to many).
same from prod to prodModule and prodModule to some other table.
How can i achieve this.
I am getting the below error
Please help me how can i able to achieve this, as my visulas will be based on these relations.
Thanks in advance.
Solved! Go to Solution.
you require a many to many bridge table in between proposal and proposal_product. the bridge table would contain all valud combinations of the id's in the tables proposal and product_proposal.
Once you have the bridge you would create 1->* relationships between each table and the bridge with filter direct set to both.
Hope that helps.
We're excited to announce our first cross-community 'Can You Solve These?' challenge!
Learn about the exciting things that happened in July.
Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.
We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.