UNICHAR

The UNICHAR function returns the Unicode character corresponding to the indicated "code point".

Syntax

UNICHAR(
    number
)

Parameters
  • number: Unicode numeric code corresponding to the character to be obtained.
Returned value

The UNICHAR function returns a text string.

Additional Information

If the indicated code does not have a Unicode correspondence or if the code is zero, the function returns an error.

The result returned by the function can be a character string, for example in UTF-8 or UTF-16 format.

Examples

This example adds a calculated column that displays the character corresponding to the number in the Unicode[Código] column:

Carácter = UNICHAR('Unicode'[Código])

UNICHAR function. Example of use

In this second example we are creating a measure that concatenates a text and the numeric value returned by another measure:

Ventas = CONCATENATE("Ventas totales: ", FORMAT([Sales], "Currency"))

If we take this measure [Ventas] to a card-type display, the result is the following:

Función UNICHAR

Now, if we add the UNICHAR(10) character to the text "Ventas totales: " of the previous measure, we are forcing a line break:

Ventas = CONCATENATE("Ventas totales: " & UNICHAR(10), FORMAT([Sales], "Currency"))

Función UNICHAR
Related functions
Category
Text
Submitted by admin on Fri, 02/08/2019 - 11:43