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
utsavlexmark In DAX there is no general distinction between cases so that might be the issue if you are using SEARCH for example which is case-insensitive versus FIND which is case-sensitive. Would need to know your code though and if you are even using DAX or PQ.
- Here is the codeCountry 1 =VAR country = 'Data Sources'[Email Name]RETURNSWITCH( 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
