Character.FromNumber is a useful function in Power Query that allows you to convert a number to its corresponding character in the Unicode character set. Character.FromNumber Syntax: Character.FromNumber(number as number) as text Arguments: Return value: Example Character.FromNumber: To convert the number 65 to its corresponding character, which is ‘A’, you would use the following formula in…
Text.SplitAny is a Power Query function that allows you to split a text string into multiple parts based on one or more delimiters. This is useful when you have a text string that contains multiple values, such as a comma-separated list, and you need to extract each value individually. Syntax The Text.SplitAny function takes three…
Text.Trim power query function helps us to remove spaces from the beginning and end of the given string. It also helps to remove a particular character from both ends of the string. Syntax It takes two parameters. Text.Trim Power Query Example 1 Let’s take the following example: we have a couple of account numbers with…
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…
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…
The text.length power query function helps us count the number of characters in the given string. This article teaches how to implement the Text.length function. It comes under the category of Text functions of Power query. Syntax It takes one parameter as a string and returns its length. Text.length function is equivalent to the Len…
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 It takes two parameters. Text.Proper power query example Let’s have the following example: one column with a couple…
Text.Lower is a power query function that converts all the letters in the provided string to lowercase. In this article, we will explore Text.Lower power query function and how to use it with the help of an example. Let’s begin. Syntax It takes one parameter as a string that is compulsory and returns all the…
Text.Upper is a power query function that helps us to convert small letters to upper case. In this article, we tell you how to convert all the letters in a string to capital using Text.Upper function. Syntax It takes one parameter as a string and returns it in upper case. Text.upper Example Let’s create a…
Text.beforedelimiter is a power query function that returns the substring before a specific delimiter. It helps us to clean the data before importing it into Power BI. Syntax Text.BeforeDelimiter takes three parameters. The first two parameters are compulsory, and the third parameter is optional. Example Let’s take the following example to extract the substring using…
