Returns the starting position of one text string within another text string.
DAX FIND function is case sensitive.
FIND (<find_text>, <within_text>, [<start_num>], [<NotFoundValue>])
|Sr.No.||Parameter & Description|
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.
If you want to find an actual question mark or asterisk, type a tilde (~) before the character.
The text in which you want to search.
The character at which to start the search.
If omitted, start_num = 1. The first character in within_text is character number 1.
The value that should be returned when the DAX FIND function does not find find_text in within_text.
It should be an Integer or BLANK ().
Number (Integer) that shows the starting position of the find_text in within_text, if it is found.
If find_text is not found in within_text and NotFoundValue is specified, then that value (an Integer or BLANK ()).
If you provide the argument find_text as a text string, it should be enclosed in double quotation marks.
If find_text is not found in within_text and NotFoundValue is omitted, DAX FIND function returns #ERROR.
NotFoundValue should be an Integer or BLANK (). It should not be any other value.
If you specify start_num that is greater than the start position of the first instance of find_text in within_text, then FIND function returns a number only if a second instance of find_text exists in within_text. Otherwise, it returns NotFoundValue. You can use this to find the duplicated text within a text string.
= FIND ([ProductName], [Product Description],, BLANK ())
This returns a blank, if the product name is not mentioned in the product description.
You can use such verification to ensure that the product description contains the product name at least once.
= FIND (“Powder”, [ProductName],, BLANK ())
This returns an integer only if the product name contains the text – Powder. Otherwise, it returns blank.
You can use such verification to find different types of products.
26 Lectures 4.5 hours