Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Conditional Column from Multiple Tables

Hi All,    I have 4 tables : Main, Chq, Cash, ETRF and lookinto create Custom Column in Main Table.   Custom Column in Main Table:   Return "Cash" if Acc_no is in Cash Table    Return "Chq" i...
Need Help
AllisonKennedy's avatar
AllisonKennedy
Icon for Community Champion rankCommunity Champion
6 years ago

If I understand your problem correctly you should be able to try something like this, depending on how your relationships are setup:

 

Custom Column = IF(RELATED(CashTable[Acc_no])=MainTable[Acc_no], "Cash", 

IF(RELATED(ChqTable[Acc_no])=MainTable[Acc_no], "Chq",

IF(RELATED(ETRFTable[Acc_no])=MainTable[Acc_no], "ETRF",

"")))

 

Has this post solved your problem? Please mark it as a solution so that others can find it quickly and to let the community know your problem has been solved. 

 

If you found this post helpful, please give Kudos.

I work as a trainer and consultant for Microsoft 365, specialising in Power BI and Power Query. 

https://sites.google.com/site/allisonkennedycv