Implement New DAX Formula: EXTRACTTEXT

EXTRACTTEXT( , , [start_from], [start_num], [NotFoundValue])

Returns the text string at which a specific character or text string is first found, reading left to right for default like a LEFT(). Search is case-insensitive and accent sensitive.

PARAMETERS:
The order for the parameters like the formulas LEFT, RIGHT and MID.

=|= within_text: The text in which you want to search for find_text, or a column containing text.

=|= find_text : The text that you want to find.

You can use wildcard characters — the question mark (?) and asterisk (*) — in find_text. A question mark matches any single character; an asterisk matches any sequence of characters. If you want to find an actual question mark or asterisk, type a tilde (~) before the character.

=|= start_from (optional): The side in the within_text at which you want to start searching. If omitted [LEFT TO RIGHT] otherwise [RIGHT TO LEFT].

=|= start_num (optional): The character position in within_text at which you want to start searching. If omitted, 1.

=|= NotFoundValue (optional): The value that should be returned when the operation does not find a matching substring, typically null or BLANK() for default.

Return value
A text string containing the specified or null ( BLANK() for default).