Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Text Lookup in a Row

HI My Data is organized into Email and L1-L10 mapping into their manager. 

 

For each row i want to find out the occurance of the Organizations top guy, so that i can find the index for each row and run the processing based on that. Much like MATCH("[email protected]",A3:J3,0)  form EXCEL, 

 

TIA 

Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous,

    According to your snapshot, I think you do not need to use the whole 10 level fields. 

    You can use L1 and L2 with path functions to analyze the parent-child hierarchy, then it should simply use the PATHLENGTH, PATHITEM functions to extract the top level from the above structure.

    Parent-child hierarchies 

    Dax functions:

    Function Description
    PATH Returns a delimited text string with the identifiers of all the parents of the current identifier.
    PATHITEM Returns the item at the specified position from a string resulting from evaluation of a PATH function.
    PATHLENGTH Returns the number of parents to the specified item in a given PATH result, including self.

    Regards,

    Xiaoxin Sheng

4 Replies