cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DebbieE Senior Member
Senior Member

Conditional Column Case sensitive

Im creating flags using Text.

But it seems that its case sensitive "microsoft", "Microsoft"

 

Is there anyway I can get rid of that? I dont want to add 2 conditions when i only need one?

 

Debbie

1 ACCEPTED SOLUTION

Accepted Solutions
Gazzer Member
Member

Re: Conditional Column Case sensitive

Create your conditional column exactly as you have been doing, then go to the formula bar and edit it to be something like:

 

= Table.AddColumn(#"Renamed Columns", "MyConditionalCol", each if Text.Lower([MyColumn]) = "microsoftazure" then 1 else 0)

 

The key bit is wrapping Text.Lower() around the column name and making sure the comparitor is also lowercase.

 

image.png

View solution in original post

5 REPLIES 5
DebbieE Senior Member
Senior Member

Re: Conditional Column Case sensitive

Ive come up with a workaround

Create a duplicate column, change everything to lower case and use that. Then hide this column

Community Support Team
Community Support Team

Re: Conditional Column Case sensitive

Hi DebbieE,

 

Could you share some sample data and clarify more info about your expected result?

 

Regards,

Jimmy Tao

DebbieE Senior Member
Senior Member

Re: Conditional Column Case sensitive

Yes, I have a twitter test field. If for example you had

1 MicrosoftAzure

2 microsoftazure

3 Microsoftazure

4 microsoftAzure

 

Currently it seems if you go to New Conditional Column. And Add a If Text Contains microsoftazure  Then 1 You will only get a flag set against 2

 

I dont want to set 4 conditions, which will potentially miss other mixes of capitals and none capitals. The only way around this I could think of is to Duplicate Text. Change to lower case and use this as the basis of the condition

Gazzer Member
Member

Re: Conditional Column Case sensitive

Create your conditional column exactly as you have been doing, then go to the formula bar and edit it to be something like:

 

= Table.AddColumn(#"Renamed Columns", "MyConditionalCol", each if Text.Lower([MyColumn]) = "microsoftazure" then 1 else 0)

 

The key bit is wrapping Text.Lower() around the column name and making sure the comparitor is also lowercase.

 

image.png

View solution in original post

Highlighted
DebbieE Senior Member
Senior Member

Re: Conditional Column Case sensitive

Fantastic,

 

Thank you 

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 282 members 2,993 guests
Please welcome our newest community members: