DAX parent and child functions

• The PATH() function compares a child key column with the parent key column and returns a delimited text string containing all the parent members for the given row

• The PATHITEM() function returns the key value from a path from highest to lowest based on the position parameter.
  • The third and final parameter to this function (1) indicates to return this value as an integer.
• The LOOKUPVALUE() function compares the account key with the key returned by the PATHITEM() function