Conditional Column Case sensitive

[DebbieE]

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

[DebbieE]

Ive come up with a workaround

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

[v-yuta-msft]

Hi DebbieE,

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

Regards,

Jimmy Tao

[DebbieE]

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 · Accepted solution]

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.

[DebbieE]

Fantastic,

Thank you