Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Picking the same value from 2 columns under the same table

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 somethi...
General Comment
Interesting Links
  • Phil_Seamark's avatar
    Phil_Seamark
    8 years ago

    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
    )
Phil_Seamark's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

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
    )