FIND

Syntax

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

In today’s DAX Fridays! tutorial we are going to go though examples on how to use two DAX functions: SEARCH and FIND SEARCH and FIND DAX functions are used to find the number of characters at which a specific word is found in a column.

Keynotes:

00:58 SEARCH function DAX Microsoft Documentation
02:20 DAX search function without options
04:00 DAX search function with options
04:43 DAX search function Error validation options
05:49 DAX search function with * wildcard
07:00 DAX search function with ? wildcard
08:52 Search and Switch functions
10:35 Find function DAX Microsoft Documentation
10:57 Find function explained
11:32 Find vs Search function

Download example file:

Link to Power BI file: here.

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 http://go.microsoft.com/fwlink/?LinkId=219171.