Table of contents
Collapse the table of content
Expand the table of content

FIND Function (DAX)

Owen Duncan|Last Updated: 10/5/2018
1 Contributor

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


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


find_textThe text you want to find. Use double quotes (empty text) to match the first character in within_text.
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().

Property Value/Return Value

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

FIND does not support wildcards. To use wildcards, use SEARCH.


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")  

See Also

Text Functions (DAX)

© 2018 Microsoft