Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Referencing a List from a Different Table in a Column

Hi!


I am trying to create a column that returns logic based on a list from another table.

 

For example, this is the "Master List":
 

 

I have 2 seperate tables of addresses:

 

TABLE1

 

TABLE2

 

I want for the column to return results based on the following logic:

  • If Client Address = listed in the company addresses1, "From Company"
  • IF resolver Address =listed in the company addresses1, "To Company"
  • Else, "undetermined"

 

 

Here is an example result.


Any help appreciated!

Need Help
  • AlB's avatar
    AlB
    6 years ago

    Hi Anonymous 

     

    Direction =
SWITCH (
    TRUE (),
    MasterTable[Client Address] IN DISTINCT ( Table1[Company addresses 1] ), "From Company",
    MasterTable[Resover Address] IN DISTINCT ( Table2[Company addresses 2] ), "To Company",
    "undetermined"
)

    Please mark the question solved when done and consider giving kudos if posts are helpful.

     

    Cheers  Datanaut

     

1 Reply

  • AlB's avatar
    AlB
    Icon for Community Champion rankCommunity Champion
    6 years ago

    Hi Anonymous 

     

    Direction =
SWITCH (
    TRUE (),
    MasterTable[Client Address] IN DISTINCT ( Table1[Company addresses 1] ), "From Company",
    MasterTable[Resover Address] IN DISTINCT ( Table2[Company addresses 2] ), "To Company",
    "undetermined"
)

    Please mark the question solved when done and consider giving kudos if posts are helpful.

     

    Cheers  Datanaut