Text.Proper Power query function

Text.Proper Power Query function

ByPower BI

Text.Proper function in power query helps us to capitalize the first letter of every word in the given string. In this article, we will learn how to implement Text.Proper function with the help of an example.

Syntax

Text.Proper(Given string)

It takes two parameters.

  • The first parameter is the given string.
  • The second parameter is optional, called culture. It depends on the language & country setting of your computer.

Text.Proper power query example

Let’s have the following example: one column with a couple of names in small letters, as you can see below.

small letters name dataset

We will use text.proper function to change these names in the proper case.

Text.Proper([Lower Case])

The “Lower Case” is the column name that contains names in small letters. After applying the function, we will get the following result.

Text.Proper power query function

To learn more, please visit Learn DAX

Similar Posts

Text.TrimEnd Power Query to remove spaces from the end of string

ByPower BI

Text.TrimEnd power query function helps us to remove spaces or any character from the end of the given string. It comes under the category of power query Text functions. It is a very helpful function for data cleaning. Syntax It takes two parameters. Text.TrimEnd Power Query Example We have some account numbers with additional spaces…

Understanding Lambda Functions in Power Query

Understanding Lambda Functions in Power Query

ByPower BI

Lambda functions in Power Query are a powerful feature introduced to make it easier to perform complex operations on data without needing to create multiple helper columns or complex nested functions. Let’s start with some basic concepts and then move on to a practical example. What is a Lambda Function? A Lambda function is essentially…

Power Query Left Function

Power Query Left Function using Text.Start

ByPower BI

The power query left function can be replicated using Text.Start function. In most languages, we use the left function to extract the desired number of characters from the left side of the given string. The syntax of the Text.Start function in the Power query is straightforward. It takes two parameters. Power Query left function example….

Text.TrimStart Power Query

Text.TrimStart Power Query to remove leading zeros

ByPower BI

Text.TrimStart power query function helps us to remove the leading zeros from the given string. It comes under the category of Power query text functions. Syntax It takes two parameters. Text.TrimStart power query function Example Let’s take the following example in which we have some account numbers with leading zeros, and we want to remove…