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                          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

  • 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

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