2 conditions - Conditional column

[adityavighne]

Hi,

I want to create a conditional column with below conditions – how to create this?

1. PageURL - contains – abc AND PageURL - contains – def

OR

     2.PageURL - contains – ghi AND PageURL - contains – jkl

I don’t want to add 2 times PageURL in my filter section, because it’s not giving correct results

[v-cherch-msft]

Hi @adityavighne 

Kindly mark the helpful answer as a solution if you feel that makes sense.If not,please share more data and your expected output.

Regards,

Cherie

[PattemManohar]

@adityavighne  Please try this as a New column in Data pane using below DAX

Flag = IF(
             (SEARCH("abc",Table[PageURL])>0 && SEARCH("def",Table[PageURL])>0)
          || (SEARCH("ghi",Table[PageURL])>0 && SEARCH("jkl",Table[PageURL])>0)
          ,"Y","N"
         )

[adityavighne]

thanks for the reply.

I'm getting below error -

"The search Text provided to function 'SEARCH' could not be found in the given text.

[Nishantjain]

The search function given an error when the condition provided is not valid. Wrap it in ISERROR function to capture the error. 

Something like this:

Flag = IF(
             iserror((SEARCH("abc",Table[PageURL])>0 && SEARCH("def",Table[PageURL])>0))=false()
          || iserror((SEARCH("ghi",Table[PageURL])>0 && SEARCH("jkl",Table[PageURL])>0))=false()
          ,"Y","N"
         )

[adityavighne]

iserror gives boolean value - which will not resolve my problem.

[adityavighne]

I resolve this issue - 

Flag = SEARCH("abc",[Pages],1,BLANK() && SEARCH("def",[Pages],1,BLANK()))

           || SEARCH("ghi",[Pages],1,BLANK() && SEARCH("jkl",[Pages],1,BLANK()))

[PattemManohar · Accepted solution]

@adityavighne 

Flag = 
       IF( 
             (SEARCH("abc",Test256Search[Name],,0)>0 && SEARCH("def",Test256Search[Name],,0)>0)
          || (SEARCH("ghi",Test256Search[Name],,0)>0 && SEARCH("jkl",Test256Search[Name],,0)>0)
          ,"Y","N"
         )