Text.TrimStart Function in Power Query
The Text.TrimStart returns the resultant text after removing all leading whitespace from the input text.
Syntax
Text.TrimStart(text as nullable text, optional trim as any) as nullable text
Example: Remove leading whitespace from the input text.
Power Query M
= Text.TrimStart(" Ashish Goel ") The output will be “Ashish Goel ". The output will be shown in the following image.
