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.
Hey there!
So I have the following table:
name | email | utm Jim | example1@gmail.com | | utm_source=soc | utm_medium=facebook | utm_campaign=France
John | example2@gmail.com | | utm_source=soc | utm_medium=facebook | utm_campaign=Brazil
..
I have created an additional calculated column called UtmCampaign, which allows me to pull just the value of the utm_campaign. For example, out of the 1st row, it would only show "France", this is my calculated column:
IFERROR(MID(MID('MyLeads'[utm], FIND("utm_campaign", 'MyLeads'[utm], 1), FIND("|", 'MyLeads'[utm], FIND("utm_campaign", 'MyLeads'[utm], 1))-1 -FIND("utm_campaign", 'MyLeads'[utm], 1)), FIND("=", MID('MyLeads'[utm], FIND("utm_campaign", 'MyLeads'[utm], 1), FIND("|", 'MyLeads'[utm], FIND("utm_campaign", 'MyLeads'[utm], 1))-1 -FIND("utm_campaign", 'MyLeads'[utm], 1)), 1)+1, LEN(MID('MyLeads'[utm], FIND("utm_campaign", 'MyLeads'[utm], 1), FIND("|", 'MyLeads'[utm], FIND("utm_campaign", 'MyLeads'[utm], 1))-1 -FIND("utm_campaign", 'MyLeads'[utm], 1)))), "")
It works fine, the only issue is that for some strange reason, it outputs "France" as "france" (in lowercase).
I am not sure what could be causing the issue, would appreciate some assistance.
P.S.: My PowerBI Desktop version is the latest.
Thanks!
Solved! Go to Solution.
hi, @analystict
I have tested on my side, but not reproduce the issue.
Could you share your simple sample pbix file for us to have a test?
Best Regards,
Lin
hi, @analystict
You need to distinguish them in Power query, for example add an index.
Because of Case - insensitive in DAX.
Best Regards,
Lin
hi, @analystict
I have tested on my side, but not reproduce the issue.
Could you share your simple sample pbix file for us to have a test?
Best Regards,
Lin
Hi,
Thanks for the reply!
The issue is that there are utms with "france" also (in lowercase), and apparently PowerBI cannot tell the difference (that's what I assume and saw in other posts searching similar issues on Google).
Is there a way to overcome this so PowerBI will tell the difference between "France" and "france"?
HI, @analystict
You could replace "France" with "france" in power query
Best Regards,
Lin
Hey there,
What if I have both though? Isn't there some workaround for PowerBI to tell the difference between lower & uppercase?
Thanks!
hi, @analystict
You need to distinguish them in Power query, for example add an index.
Because of Case - insensitive in DAX.
Best Regards,
Lin
Thank you!
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 |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |