Forum Discussion

anwarbi's avatar
anwarbi
Helper III
4 years ago
Solved

Creating a new column based on values from two different columns

I have two tables-  Table 1 and Table 2 (refer below tables) . Table 1 has all the customer names and table 2 has a list of selected customers.    I want to create a column in Table 1 with a flag "...
Need Help
  • v-zhangti's avatar
    v-zhangti
    4 years ago

    Hi, anwarbi 

     

    You can try the following methods.

    Column = 
IF (
    LOOKUPVALUE (
        Table2[Selected customers],
        Table2[Selected customers], [Customers]
    )
        <> BLANK (),
    "Y",
    "N"
)

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-zhangti's avatar
v-zhangti
Community Support
4 years ago

Hi, anwarbi 

 

You can try the following methods.

Column = 
IF (
    LOOKUPVALUE (
        Table2[Selected customers],
        Table2[Selected customers], [Customers]
    )
        <> BLANK (),
    "Y",
    "N"
)

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.