Text.End
The last characters of a text.
Group: Text and characters. Power Query M has it too: a query that uses it is written as in Power BI.
Syntax
Text.End(text as nullable text, count as number) as nullable text| Parameter | Type | Description |
|---|---|---|
text | nullable text | The text to work on; null gives null. |
count | number | How many characters to keep. |
Returns
nullable text. The last characters; the whole text when it is shorter than the count.
Examples
The postcode at the end
Text.End("NO-0150", 4)"0150"