Returns the starting position of one text string within another text string. SEARCH is not case-sensitive.
The text you want to find. You can use the ? and * wildcard characters; use ~? and ~* to find the ? and * characters.
The text in which you want to search for FindText.
The character position in WithinText at which you want to start searching. If omitted, the default value is 1.
The numeric value to be returned if the text is not found; if omitted, an error is returned.
The number of the starting position of the first text string from the first character of the second text string.
SEARCH supports wildcards, whereas FIND does not.
Other related functions are:
Contributors: Alberto Ferrari, Marco Russo
MSDN documentation: https://docs.microsoft.com/en-us/dax/search-function-dax