Text.Proper Function in Power Query
The Text.Proper function returns a text value with first letters of all words converted to uppercase, and all other letters are returned in lowercase.
Syntax
Text.Proper(text as nullable text, optional culture as nullable text) as nullable text
Example: Use Text.Proper on a simple sentence.
Power Query M
= Text.Proper("Hello my deaR ashish Goel") The output of the above formula is shown below:
