Forum Discussion
Solved
Custom Column's Query showing Discrepancy
Hello, Let me share the data first Country Email Name Germany EMEA_CHAN_PN_Newsletter_EMAIL_Q3_08_2021_de_AT_BSD Germany EMEA_CHAN...
utsavlexmark Change your SEARCH to FIND
Here is the code
Country 1 =
VAR country = 'Data Sources'[Email Name]
RETURN
SWITCH( TRUE(),
SEARCH( "_NL_",country,1, 0) > 0 , "Netherland",
SEARCH( "_BE_", country,1, 0) > 0 , "Belgium",
SEARCH( "_DE_", country,1, 0) > 0 , "Germany",
SEARCH( "_AT_", country,1, 0) > 0 , "Austria",
SEARCH( "_CH_", country,1, 0) > 0 , "Switzerland",
SEARCH( "_FR_", country,1, 0) > 0 , "France",
SEARCH( "_SE_", country,1, 0) > 0 , "Sweden",
SEARCH( "_DK_", country,1, 0) > 0 , "Denmark",
SEARCH( "_FI_", country,1, 0) > 0 , "Finland",
SEARCH( "_NO_", country,1, 0) > 0 , "Norway",
SEARCH( "_GB_", country,1, 0) > 0 , "UK",
SEARCH( "_UK_", country,1, 0) > 0 , "UK"
)
utsavlexmark Change your SEARCH to FIND