MID DAX Function in Power BI

The MID dax function returns a string of characters from the middle of a text string, given a starting position and length.

DAX Syntax MID(text, start_num, num_chars)

The function has the following parameters:

Example: Let’s create a calculated column.

DAX

MID Column = MID('Branch details'[Branch], 2, 3)

The output of the above dax function is shown below:

MID dax function in Power BI