Text.PadEnd Function in Power Query
The Text.PadEnd function returns text of a specified length by padding the optional character at the end of the given text. An optional character can be used to specify the character used for padding. The default pad character is a space.
Syntax
Text.PadEnd(text as nullable text, count as number, optional character as nullable text) as nullable text
Example:
Power Query M
let
Source =Text.PadEnd("Ashish", 10)
in
Source The output of the above code is “Ashish ”.
Power Query M
let
Source = Text.Length(Text.PadEnd("Ashish", 10))
in
Source The output of the above code is 10.