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 something like below:

 

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

 

Could you please help me?

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
    )

1 Reply

  • Phil_Seamark's avatar
    Phil_Seamark
    Microsoft 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
    )