Adding a new column to search for words but using Comparer.IgnoreOriginalCase

[Mr_Mr]

Morning all,

Struggling a wee bit here to get the DAX to work for me. Looking to use Add Custom Column and utilise Comparer.IgnoreOriginalCase to allow me to create a column which searches into two columns but would need the search to ignore the case sensitivity of the search word as can be words.

Any help greatly appreciated.

Thanks. 

[vicky_ · Accepted solution]

Are you using DAX or M? "Comparer.IgnoreOriginalCase" looks like a M parameter, in which case, it's fine, but DAX has options for case sensitive (FIND() function) and insenstivie (SEARCH() function) so there's no need to specify as a parameter.