IF ISERROR WITH MORE THAN VALUES

[Anonymous]

Hi there, 

I'm looking for a way to select only the values that contains "B2B" & "BTOB" name them B2B and name the rest "B2C".

I tried this one but it doesn't work :

Column = IF(

    ISERROR(

        SEARCH("B2B" OR "BTOB", clixray_fr_reporting_export_campaigns_campaigns_results[tags])

    ),

    "B2C",

    "B2B"

)

The aim is : 

If it doesn't contain 'B2B' OR 'BTOB' --> B2C

Otherwise --> B2B

Can you please help me please ?

[Payeras_BI]

hi @Anonymous ,

Regards,

[Anonymous]

Hi @Payeras_BI,

Thanks for your reply. Here's my search column values. As you can see this solution can't work because the values doesn't contain only B2B, BTOB etc... The aim is to ask Power BI to name look for the values that contains BTOB and B2B and name them B2B and name the rest B2C.

[Payeras_BI · Accepted solution]

Hello again @othmanbelmouzo,

I didn't notice the word "contains" when I first read it.

What about this?

[Anonymous]

Hi @Syndicate_Admin,

Thanks for your solution, it works for me 😉

Best regards,

Othman