PowerBI Insists showing calculated column values in lowercase

[analystict]

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!

[v-lili6-msft · Accepted 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

[v-lili6-msft · Accepted 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

[analystict]

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"?

[v-lili6-msft]

HI, @analystict 

You could replace "France" with "france" in power query

Best Regards,

Lin

[analystict]

Hey there,

What if I have both though? Isn't there some workaround for PowerBI to tell the difference between lower & uppercase?

Thanks!

[v-lili6-msft · Accepted solution]

hi, @analystict 

You need to distinguish them in Power query, for example add an index.

Because of Case - insensitive in DAX.

Best Regards,

Lin

[analystict]

Thank you!