Character.FromNumber in Power Query to Convert Numbers to Unicode Character

ByPower BI

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:

  • number: The number you want to convert to a character. This can be any valid integer between 0 and 1,114,111.

Return value:

  • A text value representing the character corresponding to the given number in the Unicode character set.

Example Character.FromNumber:

To convert the number 65 to its corresponding character, which is ‘A’, you would use the following formula in Power Query:

Character.FromNumber(65)

This would return the text value ‘A’.

It’s worth noting that the number you provide to the function must be within the valid range of Unicode characters, otherwise the function will return an error. Additionally, the function only supports whole numbers, so you cannot use decimal or fractional values as input.

Overall, Character.FromNumber is a powerful function in Power Query that can be used to convert numbers to their corresponding characters in the Unicode character set.

To learn more, please visit Learn DAX

Similar Posts

How to use Power Query Text.StartsWith() range of values

How to use Power Query Text.StartsWith() range of values

ByPower BI

The Text.StartsWith() function in Power Query (M Language) is used to check if a text string starts with a specific substring. However, when you want to check if a text starts with any one of a range of values, you’ll need to slightly modify your approach because Text.StartsWith() natively handles only a single text value…

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…

Text.PadStart in Power BI

How to use Text.PadStart in Power BI?

ByPower BI

In this article we will what Text.PadStart is, the syntax and show you how to use it. Text.PadStart is a Power Query function that returns a text value padded to length count by inserting spaces at the start of the text value text. An optional character character can be used to specify the character used for padding. The default pad character is…

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….