Text.Start Function in Power Query

The Text.Start function returns the first count characters of given input text as a text value.

Syntax

Text.Start(text as nullable text, count as number) as nullable text

Example: Get the first 3 characters of "Ashish".

Power Query M

=Text.Start("Ashish", 3)

The output of the above code is "Ash".

Previous Next