Share via


FIND Function (DAX)

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

Syntax

FIND(<find_text, within_text, start_num)

Parameters

Term

Definition

find_text

The text you want to find. Use double quotes (empty text) to match the first character in within_text; wildcard characters not allowed.

within_text

The text containing the text you want to find.

start_num

The character at which to start the search; if omitted, start_num = 1. The first character in within_text is character number 1.

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, PowerPivot for Excel uses Unicode and counts each character the same way; therefore, you do not need to use a different version depending on the character type.

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

See Also

Other Resources