- DAX Functions - Home
- DAX Functions - Introduction
- DAX Parameter Naming Conventions
- Description Structure
- DAX Functions - Aggregation
- DAX Functions - Filter
- DAX Functions - Time Intelligence
- DAX Functions - Date and Time
- DAX Functions - Information
- DAX Functions - Logical
- Math & Trigonometric Functions
- DAX Functions - Parent & Child
- DAX Functions - Statistical
- DAX Functions - Text
- DAX Functions - Other
DAX Text - FIND function
Description
Returns the starting position of one text string within another text string.
DAX FIND function is case sensitive.
Syntax
FIND (<find_text>, <within_text>, [<start_num>], [<NotFoundValue>])
Parameters
| Sr.No. | Parameter & Description |
|---|---|
| 1 |
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.
If you want to find an actual question mark or asterisk, type a tilde (~) before the character. |
| 2 |
within_text The text in which you want to search. |
| 3 |
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. |
| 4 |
NotFoundValue Optional. 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 (). |
Return Value
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 ()).
Remarks
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.
Example
= 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.