FIND Function
Returns the starting position of one text string within another text string. FIND is case-sensitive.
Syntax
FIND(<find_text>, <within_text>[, [<start_num>][, <NotFoundValue>]])
Parameters
Term |
Definition |
|---|---|
find_text |
The 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_text |
The 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(). |
Property Value/Return Value
Number that shows the starting point of the text string you want to find.
Remarks
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 https://go.microsoft.com/fwlink/?LinkId=219171.
Example
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")