DAX Function Reference - Visual Intelligence - page 375

FuNCTIoN DESCrIPTIoN

IFERROR(< value >,
< value_if_error >)

Evaluates an expression and returns
a specified value if the expression
returns an error; otherwise returns
the value of the expression itself.

NOT(< logical >) Changes FALSE to TRUE , or TRUE to

FALSE .

OR(< logical1 >, < logical2 >) Checks whether one of the argu-

ments is TRUE to return TRUE . The
function returns FALSE if all argu-
ments are FALSE .

SWITCH(< expression >, < value1 >,
< result1 >, < value2 >,
< result2 >…, < else >)

Evaluates an expression against a list
of values and returns one of multiple
possible result expressions. else is
the result if expression doesn't match
any of the value arguments (optional).

TRUE() Returns the logical value TRUE .

TExT FuNCTIoNS

Text functions, as shown in Table B-7, are used for formatting text.

TABle B-7 Text Functions

FuNCTIoN DESCrIPTIoN

BLANK() Returns a blank.

CONCATENATE(< text1 >, < text2 >) Joins two text strings into one text

string.

EXACT(< text1 >,< text2 >) Compares two text strings and

returns TRUE if they are exactly the
same, FALSE otherwise. EXACT is
case-sensitive but ignores formatting
differences.

FIND(< find_text >,
< within_text >,
< start_num >, < NotFoundValue >)

Returns the starting position of one
text string within another text string.
FIND is case-sensitive. start_num and
NotFoundValue are optional.

FIXED(< number >, < decimals >,
< no_commas >)

Rounds a number to the specified
number of decimals and returns the
result as text. You can specify that the
result be returned with or without
commas.