FIND Function

FIND Function (DAX)

 

Returns the starting position of one text string within another text string. FIND is case-sensitive.

FIND(<find_text>, <within_text>[, [<start_num>][, <NotFoundValue>]])  

Parameters

TermDefinition
find_textThe text you want to find. Use double quotes (empty text) to match the first character in within_text.

You can use wildcard characters — the question mark (?) and asterisk (*) — in find_text. A question mark matches any single character; an asterisk matches any sequence of characters. If you want to find an actual question mark or asterisk, type a tilde (~) before the character.
within_textThe text containing the text you want to find.
start_num(optional) The character at which to start the search; if omitted, start_num = 1. The first character in within_text is character number 1.
NotFoundValue(optional) The value that should be returned when the operation does not find a matching substring, typically 0, -1, or BLANK().

Number that shows the starting point of the text string you want to find.

Whereas Microsoft Excel has multiple versions of the FIND function to accommodate single-byte character set (SBCS) and double-byte character set (DBCS) languages, DAX uses Unicode and counts each character the same way; therefore, you do not need to use a different version depending on the character type.

This DAX function may return different results when used in a model that is deployed and then queried in DirectQuery mode. For more information about semantic differences in DirectQuery mode, see http://go.microsoft.com/fwlink/?LinkId=219171.

The following formula finds the position of the first letter of the product designation, BMX, in the string that contains the product description.

=FIND("BMX","line of BMX racing goods")  

Text Functions (DAX)

Community Additions

ADD
Show:
© 2016 Microsoft