Table of contents
TOC
Collapse the table of content
Expand the table of content

UNICHAR Function (DAX)

Owen Duncan|Last Updated: 10/5/2018
|
1 Contributor

Returns the Unicode character referenced by the numeric value.

Syntax

UNICHAR(number)  

Parameters

TermDefinition
numberThe Unicode number that represents the character.

Return Value

A character represented by the Unicode number

Remarks

If XML characters are not invalid, UNICHAR returns an error.

If Unicode numbers are partial surrogates and data types are not valid, UNICHAR returns an error.

If numbers are numeric values that fall outside the allowable range, UNICHAR returns an error.

If number is zero (0), UNICHAR returns an error.

The Unicode character returned can be a string of characters, for example in UTF-8 or UTF-16 codes.

Example

The following example returns the character represented by the Unicode number 66 (uppercase A).

=UNICHAR(65)

The following example returns the character represented by the Unicode number 32 (space character).

=UNICHAR(32)

The following example returns the character represented by the Unicode number 9733 (★ character).

=UNICHAR(9733)
© 2018 Microsoft