Forum Discussion
Text.Contain in M Query to check if Value Column Contains Consonant
Hello, I need help. I am using a table to create a new column that checks a column named Value for a consonant. If it contains a consonant, the column is true. Otherwise, it is false. The formula w...
Use this
List.ContainsAny(Text.ToList(Text.Lower([Value])), List.Difference({"b".."z"}, {"e", "i", "o", "u"}))
Just remove both of the "= true", because that's already implied by the via function return value--in other words, if text contains this then do this else do that.
--Nate