Text.End Function in Power Query

The Text.End function returns a text value that is the last count characters of the given text value.

Syntax

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

Example: Get the last 9 characters from the given text.

Power Query M

let
    Source = Text.End("https://ashishcoder.com", 9)
in
    Source

The output of the above code is “coder.com”.

Previous Next