Forum Discussion
SEARCH Function with IF Statement
I am trying to flag a list of item in a Product Name column using the SEARCH function. I have tried using both an IF Statement as well as a SWITCH function. Essentially I am wanting to flag in a ca...
Anonymous try this
=If( SEARCH("*Gift Card*", 'Product'[ProductName],,-1)>=0 || SEARCH("*Play*", 'Product'[ProductName],,-1)>=0 || SEARCH("*Rental*", 'Product'[ProductName],,-1)>=0 || SEARCH("*Refund*",'Product'[ProductName],,-1)>=0 || SEARCH("*Service Fee*", 'Product'[ProductName],,-1)>=0 || SEARCH("*Prior Day*", 'Product'[ProductName],,-1)>=0 || SEARCH("*Activation*", 'Product'[ProductName],,-1)>=0 || SEARCH("*Award*", 'Product'[ProductName],,-1)>=0 || SEARCH("*Booking*", 'Product'[ProductName],,-1)>=0 || SEARCH("*Ticektless*", 'Product'[ProductName],,-1)>=0 || SEARCH("*Lanyard*", 'Product'[ProductName],,-1)>=0 , 1,0)
Anonymous try this
=If(
SEARCH("*Gift Card*", 'Product'[ProductName],,-1)>=0
|| SEARCH("*Play*", 'Product'[ProductName],,-1)>=0
|| SEARCH("*Rental*", 'Product'[ProductName],,-1)>=0
|| SEARCH("*Refund*",'Product'[ProductName],,-1)>=0
|| SEARCH("*Service Fee*", 'Product'[ProductName],,-1)>=0
|| SEARCH("*Prior Day*", 'Product'[ProductName],,-1)>=0
|| SEARCH("*Activation*", 'Product'[ProductName],,-1)>=0
|| SEARCH("*Award*", 'Product'[ProductName],,-1)>=0
|| SEARCH("*Booking*", 'Product'[ProductName],,-1)>=0
|| SEARCH("*Ticektless*", 'Product'[ProductName],,-1)>=0
|| SEARCH("*Lanyard*", 'Product'[ProductName],,-1)>=0
, 1,0)
That seems to have worked! Thank you very much.