DAX Function Reference - Visual Intelligence - page 374

TABle B-5 Parent-Child Functions

FuNCTIoN DESCrIPTIoN

PATH(< ID_column >,
< parent_column >)

Returns a delimited text string with
the identifiers of all the parents of the
current identifier, starting with the
oldest and continuing until current.

PATHCONTAINS(< path >, < item >) Returns TRUE if the specified item

exists within the specified path.

PATHITEM(< path >, < position >[,
< type >])

Returns the item at the specified posi-
tion from a string resulting from eval-
uation of a PATH function. Positions
are counted from left to right. type is
an optional enumeration that defines
the data type of the result ( Text or
Integer ).

PATHITEMREVERSE(< path >,
< position >[, < type >])

Returns the item at the specified posi-
tion from a string resulting from eval-
uation of a PATH function. Positions
are counted backwards from right to
left.

PATHLENGTH(< path >) Returns the number of parents to the

specified item in a given PATH result,
including self.

LoGICAL FuNCTIoNS

Logical functions, shown in Table B-6, are used for comparisons within a
function.

TABle B-6 Logical Functions

FuNCTIoN DESCrIPTIoN

AND(< logical1 >, < logical2 >) Checks whether both arguments are

TRUE , and returns TRUE if both argu-
ments are TRUE . Otherwise it returns
FALSE .

FALSE() Returns the logical value FALSE .

IF(< logical_test >,
< value_if_true >,
< value_if_false >)

Checks if a condition provided as the
first argument is met. Returns one
value if the condition is TRUE , and
returns another value if the condition
is FALSE .