Database Reference
In-Depth Information
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.