- DAX Functions Tutorial
- DAX Functions - Home
- DAX Functions - Introduction
- DAX Parameter Naming Conventions
- Description Structure
- DAX Functions - Aggregation
- DAX Functions - Filter
- DAX Functions - Time Intelligence
- DAX Functions - Date and Time
- DAX Functions - Information
- DAX Functions - Logical
- Math & Trigonometric Functions
- DAX Functions - Parent & Child
- DAX Functions - Statistical
- DAX Functions - Text
- DAX Functions - Other
- DAX Functions Useful Resources
- DAX Functions - Quick Guide
- DAX Functions - Useful Resources
- DAX Functions - Discussion
DAX Parent & Child - PATHITEM function
Description
Returns the item at the specified position from a string, resulting from an evaluation of a PATH function.
Positions are counted from the left to the right.
Syntax
PATHITEM (<path>, <position>, [<type>])
Parameters
Sr.No. | Parameter & Description |
---|---|
1 |
path A text string in the form of the results of a PATH function. |
2 |
position An integer expression with the position of the item to be returned. |
3 |
type Optional. An enumeration that defines the data type of the result. TEXT or 0: Results are returned with the data type text. (If omitted, this is default). INTEGER or 1: Results are returned as integers. |
Return Value
The identifier returned by the PATH function at the specified position in the list of identifiers
Items returned by the PATH function are ordered by the most distant to the current.
Remarks
This function can be used to return a specific level from a hierarchy returned by a PATH function.
If you specify a number for position that is less than one (1) or greater than the number of elements in path, DAX PATHITEM function returns BLANK.
If type is not a valid enumeration element, an error is returned.
Example
Suppose you want to return just the skip-level managers for all employees.
= PATHITEM(PATH(Employee[EmployeeID], Employee[ManagerEmployeeID]), Employee[P ath Length]-2)