topic Re: Using Switch and Contains for Multiple Conditions in DAX Commands and Tips

Using Switch and Contains for Multiple Conditions

Bgordon10 — Thu, 17 Mar 2022 22:41:19 GMT

Hello,

I have a dataset with two specific columns, Marketing_grouping and campaign_name. I want to create a new column that reads the text string in the campaign_name column and returns a value. We want to identify if the campaign is a Brand or NonBrand campaign. There are other campaigns that are not Brand or Nonbrand specific, so if possible, the new column would return the Marketing grouping. Essentially we are splitting the Marketing_Grouping, Paid Search, into 2 groups, brand and nonbrand, and using the campaign name column to identify. Also, there are paid search campaigns that do no have brand or nonbrand in Its name and we will group them under nonbrand

** Case sensitive:

If campaign_name contains NB, Non, non, Non-Brand, and Marketing group = Paid Search, then NB

If Campaign_Name contains Brand, BR, and marketing group = Paid Search, then Brand

If Marketing_group = Paid Search and Campaign name doesn't contain any of the above, then NB

Else, Marketing_Group (all other non paid search campaigns, use marketing group)

Re: Using Switch and Contains for Multiple Conditions

amitchandak — Fri, 18 Mar 2022 01:12:11 GMT

Bgordon10 , You can use Switch and find in DAx to create a new column

SEARCH and FIND: https://www.youtube.com/watch?v=mZt0HJw4gjQ&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=45

Switch-Case statement of #PowerBI: https://www.youtube.com/watch?v=gelJWktlR80&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=56

Re: Using Switch and Contains for Multiple Conditions

Bgordon10 — Fri, 18 Mar 2022 17:02:20 GMT

Thanks amitchandak !

But now I am getting an error message, and I still need a formula for all other paid search campaigns that do not have the criteria in the formulas below

Re: Using Switch and Contains for Multiple Conditions

Bgordon10 — Fri, 18 Mar 2022 21:01:55 GMT

Hi,

I wanted to provide an update that I figured out a solution. See code below.

MOR Channel Type =

SWITCH (

TRUE (),

ISERROR ( FIND ( "NB", Summary[CAMPAIGN_NAME] ) ) <> TRUE ()

&& Summary[MARKETING_GROUPING] IN {"Paid Search", "UK Paid Search"}, "NB",

ISERROR ( FIND ( "Non", Summary[CAMPAIGN_NAME] ) ) <> TRUE ()

&& Summary[MARKETING_GROUPING] IN {"Paid Search", "UK Paid Search"}, "NB",

ISERROR ( FIND ( "non", Summary[CAMPAIGN_NAME] ) ) <> TRUE ()

&& Summary[MARKETING_GROUPING]IN {"Paid Search", "UK Paid Search"}, "NB",

ISERROR ( FIND ( "Non Brand", Summary[CAMPAIGN_NAME] ) ) <> TRUE ()

&& Summary[MARKETING_GROUPING] IN {"Paid Search", "UK Paid Search"}, "NB",

ISERROR ( FIND ( "BR", Summary[CAMPAIGN_NAME] ) ) <> TRUE ()

&& Summary[MARKETING_GROUPING] IN {"Paid Search", "UK Paid Search"}, "Brand",

ISERROR ( FIND ( "Brand", Summary[CAMPAIGN_NAME] ) ) <> TRUE ()

&& Summary[MARKETING_GROUPING] IN {"Paid Search", "UK Paid Search"}, "Brand",

ISERROR ( NOT( Summary[CAMPAIGN_NAME] )IN {"NB", "Non", "non","Non Brand", "BR", "Brand"}) <> TRUE()

&& Summary[MARKETING_GROUPING] IN {"Paid Search", "UK Paid Search"}, "NB",

ISERROR (FIND("RSVP Page _OPH_NA_Event", Summary[CAMPAIGN_NAME] ) ) <> TRUE ()

&& Summary[MARKETING_GROUPING] = "Event"

&& Summary[ICODE] IN { "CU-Online", "CU-Onsite" }, "CU Event" ,

ISERROR (Summary[CAMPAIGN_NAME] <> "RSVP Page _OPH_NA_Event") <> TRUE ()

&& Summary[MARKETING_GROUPING] = "Event"

&& Summary[ICODE] IN { "CU-Online", "CU-Onsite" }, "CU WFS",

Summary[MARKETING_GROUPING] IN {"Paid Social", "UK Paid Social"}, "Paid Social",

Summary[MARKETING_GROUPING] IN {"Internal Website", "UK Internal Website"}, "Internal Website",

Summary[MARKETING_GROUPING] IN {"Display", "Display/OLV", "UK Display", "Internet Display"}, "Internal Website",

Summary[MARKETING_GROUPING]

)