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.

amitchandak's avatar
amitchandak
Super User
4 years ago

anwarbi , New column in table A

 

Column =

var _cnt = Countx(filter(Table2, Table2[Selected Customer] = Table1[Customer]), Table2[Selected Customer])

return

if(not(isblank(_cnt)) , "Y", "N")