FIND Function (DAX)

How does the FIND function (DAX) work?

The FIND function (DAX) returns the starting position of one text string within another text string. FIND is case-sensitive.

FIND Formula Syntax

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

How do you use the FIND function?

The FIND function is used to return the location of the first instance of find_text in within_text. FIND will return #VALUE if find_text is not found in within_text.

Related Blog Posts

Related Support Forum Posts

Find the max in a column function
How to find unused tables/queries
How to find the Due_Date

Considerations when using the FIND function

The FIND function uses the following arguments:

  1. Find_text (required argument) – This is the character or sub-string we wish to find.
  2. Within_text (required argument) – The text string that we need to search.
  3. Start_num (optional argument) – Specifies the position in the within_text string, from which the search should begin. If we omit the argument, it will take on the default value of 1, that is, it will begin the search at the start of the within_text string.

Related Video Tutorials

Formula examples using the FIND function

=FIND(“BMX”,”line of BMX racing goods”)

=IF(ISERROR(FIND(“Super”,A1,1))=TRUE,0,A2)

=FIND(“Z”,A5)

Related Course Modules

Ultimate-Beginners-Guide-To-PowerBI

DOWNLOAD

To access our comprehensive DAX formula reference guide just insert your email address below. The resource will download immediately and we’ll also email it to you.