DAX Text - MID function

Description

Returns a string of characters from the middle of a text string, given a starting position and length.

MID (<text>, <start_num>, <num_chars>)

Sr.No.	Parameter & Description
1	text The text string from which you want to extract the characters, or a column that contains text.
2	start_num A whole number representing the position of the first character you want to extract. The numbers start from 1 at the beginning of the text.
3	num_chars The number of characters to return.

Sr.No.

Parameter & Description

text

The text string from which you want to extract the characters, or a column that contains text.

start_num

A whole number representing the position of the first character you want to extract. The numbers start from 1 at the beginning of the text.

num_chars

The number of characters to return.

A text string.

DAX uses Unicode and stores all characters with the same length.

= MID ([Product], 1, 5), and 
= LEFT ([Product], 5) return the same characters.

However, you can use DAX MID function to extract text from the middle of the input string.

= MID ([Product],5,5) returns 5 characters starting from the 5th character.

dax_functions_text.htm