Forum Discussion
Data model help
Hey guys, I'm new to data modelling, and having some trouble setting up my data model. Here's my tables in a simplified model: Table 1 - campaign / order / line_item Table 2 - campaign / ord...
Hi JohnCavil ,
You could only have one active relationship between two tables. Make one of the relationship in active then use USERELATIONSHIP() function when you need to use this inactive relationship.
https://docs.microsoft.com/en-us/power-bi/guidance/relationships-active-inactive
https://docs.microsoft.com/en-us/dax/userelationship-function-dax
Best Regards,
Jay