check if a value is contained in another entire column and return a value if true

[mauroanelli]

hi all,

hi have two column like

A                          B

1a                       4d       

2b                       1a

3c                       2b

i need to check if the row value  in B is in any of the column A and return a true /false value  that's show me a result like

A                          B              C

1a                       4d             false

2b                       1a             true

3c                       2b              true

[v-yuta-msft · Accepted solution]

@mauroanelli ,

Also you can create calculate column using DAX below:

C = IF('Table'[B] in VALUES('Table'[A]), TRUE(), FALSE())

  

Community Support Team _ Jimmy Tao

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

[ElenaN]

Hello,

You can try this:

C = CONTAINS(Table3, Table3[A], Table3[B])

Regards,

ElenaN