Picking the same value from 2 columns under the same table

[Anonymous]

Hello Guys

I need your help

I need to create a new column, searching one specific value in two different columns in the same table and bringing a value like 1 or 0

Ideally, it should be something like below:

Column = SEARCH("client1",[Column X ],1,0) || SEARCH("client1",[Column Y],1,0)

Could you please help me?

[Phil_Seamark · Accepted solution]

Hi @Anonymous

Have you tried something like this?

Column = 
    IF (
        SEARCH("client1" , 'Table2'[Column X] , 1 , 0 ) > 0 ||
        SEARCH("client1" , 'Table2'[Column y] , 1 , 0 ) > 0 ,
        --THEN --
        1 , 
        -- ELSE -- 
        0
    )