Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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_PN_Newsletter_EMAIL_Q3_08_2021_de_AT_HW
Germany EMEA_CHAN_PN_Newsletter_EMAIL_Q3_08_2021_de_CH_BSD
Germany EMEA_CHAN_PN_Newsletter_EMAIL_Q3_08_2021_de_CH_HW
Germany EMEA_CHAN_PN_Newsletter_EMAIL_Q3_08_2021_de_DE_ALL_A
Germany EMEA_CHAN_PN_Newsletter_EMAIL_Q3_08_2021_de_DE_ALL_B
Switzerland EMEA_CHAN_PN_Newsletter_EMAIL_Q3_08_2021_fr_CH_BSD
Switzerland EMEA_CHAN_PN_Newsletter_EMAIL_Q3_08_2021_fr_CH_HW
Country is a custom column that is being created based on Email Name. The query is like "If it find the term "_AT_" the country will be Austria, If it find the term "_CH_" the country will be Switzerland, If it find the term "_DE_" the country will be Germany, and so on. "
You can see that for last 4 data the query is working correctly - but for the first 4 it is not.
I am stuck in the middle of a stange situation, any suggestion?
Regards
Utsav
Solved! Go to Solution.
@utsavlexmark Change your SEARCH to FIND
maybe you can try add column from examples
Proud to be a Super User!
@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.
@utsavlexmark Change your SEARCH to FIND
Adding to my question, if I have to pull the Country from Email Name in such way, what could be the ideal query?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
101 | |
78 | |
69 | |
63 |
User | Count |
---|---|
141 | |
106 | |
101 | |
85 | |
72 |