Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Create relationship in semantic Model data PBI

Dear Team,   I have semantic model loaded in Power BI where there is no relationship between 3 tables. all three table are independent unable to merge it since its semantic model.   table 1     ...
Need Help
Kedar_Pande's avatar
Kedar_Pande
Super User
1 year ago

Anonymous 

You can create a calculated column in Table 2:

Result =
IF(
CONTAINS(
'Table1',
'Table1'[Product], "apple"
) && 'Table2'[region] = "US",
"US Apple",
'Table1'[Product]
)
💡 If this helped, please give Kudos 👍 or mark it as a Solution ✅.
Best regards,
Kedar
| 🌐 Connect on LinkedIn
  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Issue : a single value for column x in table y can be determined.