Forum Discussion
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 "Y" if the values from Table 2 matches values in Table 1 and if they dont match then the result should be "N"
Table 1
| Customers |
| A |
| B |
| C |
| D |
| E |
| F |
| G |
| H |
Table 2
| Selected customers |
| A |
| B |
| C |
Result should be as below - Table 1 with a new column
| Customers | New Column |
| A | Y |
| B | Y |
| C | Y |
| D | N |
| E | N |
| F | N |
| G | N |
| H | N |
Thanks.
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.
2 Replies
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")
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.
