Forum Discussion

calou_33's avatar
calou_33
New Member
8 years ago
Solved

Multiple column with foreign key

Hello,   I have a table A like this   ID Field0 Field1 FIeld2 Field 3 1 tt 1 1 1 2 xx 2 2 2 3 cc 1 2 1 4 dd 2 2 1 5 yy 1 1 1 6 aa 1 1 1   Tab...
  • v-piga-msft's avatar
    v-piga-msft
    8 years ago

    Hi calou_33,

     

    You could have a try with the formulas below.

     

    Column1 = LOOKUPVALUE('TableB'[Desc],TableB[ID],'TableA'[Field1])
Column2 = LOOKUPVALUE('TableB'[Desc],TableB[ID],'TableA'[FIeld2])
Column3 = LOOKUPVALUE('TableB'[Desc],TableB[ID],'TableA'[Field 3])

    Here is the result.

     

     

    Hope this can help you!

     

     

    Best Regards,

    Cherry

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Replace your Field1,2,3 columns with the below formulas.

 

Filed1_New = IF(TableA[Filed1]=RELATED(TableB[ID]), RELATED(TableB[Desc]))

Filed2_New = IF(TableA[Filed2]=RELATED(TableB[ID]), RELATED(TableB[Desc]))

Filed3_New = IF(TableA[Filed3]=RELATED(TableB[ID]), RELATED(TableB[Desc]))

 

 

Thanks

Raj