Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 the same fields.
As such, I would need to have two connections between the same two tables, which doesn't seem workable. My solution would be to split the item table into two tables; one for components and one for finished items, but that seems like a rather unelegant way to solve this which might lead to issues with other reports.
Do you guys have any different suggestions perhaps?
Solved! Go to Solution.
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/
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/
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |