Forum Discussion
Anonymous
1 year agoNot applicable
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 table 2 table 3
Product region value
apple US 100
orange China 59
banana Denmark 40
result need in table 2 as Column = If table 1 contain 'apple' and table 2 contain 'US' then "US Apple" else table 1
Thanks!
2 Replies
- Kedar_PandeSuper User
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- AnonymousNot applicable
Issue : a single value for column x in table y can be determined.