rollingzep
Board Regular
- Joined
- Nov 18, 2013
- Messages
- 223
- Office Version
- 365
- Platform
- Windows
Hi,
I am new to Power BI.
I have 6 tables. Two tables (Tbl1 and Tbl2) have two fields which have non-unique values, SIP ID and SIN ID. There are 3 other tables with
a field, Product_ID which again has duplicate values and related to either SIP OR SIN IDs. I need to join these SIP ID and SIN ID of
Tbl1 and Tbl2 to product ID of other three tables, Tbl3, Tbl4 and Tbl5
.............................. SIP ID
Product ID ----|
................................SIN ID
How to use the Relationships to establish this many to many relation?
Or is this there an alternative method?
TIA
I am new to Power BI.
I have 6 tables. Two tables (Tbl1 and Tbl2) have two fields which have non-unique values, SIP ID and SIN ID. There are 3 other tables with
a field, Product_ID which again has duplicate values and related to either SIP OR SIN IDs. I need to join these SIP ID and SIN ID of
Tbl1 and Tbl2 to product ID of other three tables, Tbl3, Tbl4 and Tbl5
.............................. SIP ID
Product ID ----|
................................SIN ID
How to use the Relationships to establish this many to many relation?
Or is this there an alternative method?
TIA