Forum Discussion
yashwanthc
5 years agoNew Member
How to add same table twice in the model layout?
Howdy BI Users, I got an unique requirement wherein i have systemusers table which needs to have 2 active relationships (one with opportunity entity & lead entity). Is it possiblke to add systemuser...
- 5 years ago
You can duplicate or reference the table using power query.
Also you can use the USERELATIONSHIP function to activate an inactive relationship inside a measure.
Using USERELATIONSHIP in DAX - SQLBI
Reference vs Duplicate in Power BI; Power Query Back to Basics - RADACAD
camargos88
Community Champion
5 years ago
You can duplicate or reference the table using power query.
Also you can use the USERELATIONSHIP function to activate an inactive relationship inside a measure.
Using USERELATIONSHIP in DAX - SQLBI
Reference vs Duplicate in Power BI; Power Query Back to Basics - RADACAD