Forum Discussion
RandyV
7 years agoFrequent Visitor
Two connections between the same tables
Hi, I have an item table that contains both finished items and components. Most of the finished products have a bill of materials that consists of one or more components. They seem to identify on...
- 7 years ago
There is no right and wrong way, and always you have to way up the options. I have written 2 articles that may help your thinking/ option evaluation
https://exceleratorbi.com.au/multiple-relationships-between-tables-in-dax/
https://exceleratorbi.com.au/many-many-relationships-dax-explained/
MattAllington
7 years agoCommunity Champion
There is no right and wrong way, and always you have to way up the options. I have written 2 articles that may help your thinking/ option evaluation
https://exceleratorbi.com.au/multiple-relationships-between-tables-in-dax/
https://exceleratorbi.com.au/many-many-relationships-dax-explained/