DAX Function Reference - Visual Intelligence - page 373

FuNCTIoN DESCrIPTIoN

ISNUMBER(< value >) Checks whether a value is a number,

and returns TRUE or FALSE .

ISTEXT(< value >) Checks whether a value is text, and

returns TRUE or FALSE .

LooKuP FuNCTIoNS

Lookup functions, as shown in Table B-4, are used to retrieve values from
other tables for calculated columns, or can be used in calculated measures.
Note that using related tables will improve performance dramatically, and
using calculated measures will offer a processing and size improvement over
calculated columns.

TABle B-4 Lookup Functions

FuNCTIoN DESCrIPTIoN

LOOKUPVALUE( < result_column >,
< search_column1 >,
< search_value1 >[,
< search_column2 >,
< search_value2 >]…)

Returns the value in result_col-
umn for the row that meets all criteria
specified by search_column and
search_value . A replacement for
VLOOKUP in Excel, LOOKUPVALUE is
used only when relationships don't
exist.

RELATED(< column >) Returns a related value from another

table.

RELATEDTABLE(< table >) Evaluates a table expression in a

context modified by the given filters.
Returns a set of values.

VALUES(< column >) Returns a one-column table that

contains the distinct values from
the specified column including the
Unknown member.

PArENT-CHILD FuNCTIoNS

Parent-child functions, shown in Table B-5, are used to implement parent-child
hierarchies in DAX—these hierarchies are often called Ragged hierarchies.