Forum Discussion

JamieLee's avatar
JamieLee
Frequent Visitor
8 years ago
Solved

Return value from other table with condition

Hi everyone, I would appreciate some help on this:   I have two tables that are linked through an OrderID. Let’s call the tables TableA and TableB. TableA has unique OrderIDs. In TableB an OrderID...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    8 years ago

    Hi JamieLee

    In table B, create a new table

    Table = SUMMARIZE(FILTER(ALL(tableB),[KeywordGroup]="country"),[OrderID],[Keyword])

    Then edit relationship between Table A and the new table

     

    In table A, create a calculated column

    Column = RELATED('Table'[Keyword])

     

    Best Regards

    Maggie

v-juanli-msft's avatar
v-juanli-msft
Community Support
8 years ago

Hi JamieLee

In table B, create a new table

Table = SUMMARIZE(FILTER(ALL(tableB),[KeywordGroup]="country"),[OrderID],[Keyword])

Then edit relationship between Table A and the new table

 

In table A, create a calculated column

Column = RELATED('Table'[Keyword])

 

Best Regards

Maggie

JamieLee's avatar
JamieLee
Frequent Visitor
8 years ago

This works. Thanks Maggie!