DAX Function Reference - Visual Intelligence - page 376

FuNCTIoN DESCrIPTIoN

FORMAT(< value >,
< format_string >)

Converts a value to text according to
the specified format.

LEFT(< text >, < num_chars >) Returns the specified number of

characters from the start of a text
string.

LEN(< text >) Returns the number of characters in a

text string.

LOWER(< text >) Converts all letters in a text string to

lowercase.

MID(< text >, < start_num >,
< num_chars >)

Returns a string of characters from
the middle of a text string, given a
starting position and length.

REPLACE(< old_text >,
< start_num >, < num_chars >,
< new_text >)

REPLACE replaces part of a text string,
based on the number of characters
you specify, with a different text
string.

REPT(< text >, < num_times >) Repeats text a given number of times.

RIGHT(< text >, < num_chars >) RIGHT returns the last character or

characters in a text string, based on
the number of characters you specify.

SEARCH(< search_text >,
< within_text >, < start_num >,
< NotFoundValue >)

Returns the number of the charac-
ter at which a specific character or
text string is first found, reading left
to right. SEARCH is case-sensitive.
start_num and NotFoundValue are
optional.

SUBSTITUTE(< text >, < old_text >,
< new_text >, < instance_num >)

Replaces existing text with new text
in a text string.

TRIM(< text >) Removes all spaces from text except

for single spaces between words.

UPPER (< text >) Converts a text string to all uppercase

letters.

VALUE(< text >) Converts a text string that represents

a number to a number.

Predefined Numeric Formats for the ForMAT Function
Numeric formats, as shown in Table B-8, are used in the format function for
formatting numbers.