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.
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
Solved! Go to 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.
Ive come up with a workaround
Create a duplicate column, change everything to lower case and use that. Then hide this column
Hi DebbieE,
Could you share some sample data and clarify more info about your expected result?
Regards,
Jimmy Tao
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
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.
Fantastic,
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 |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |