Text Lookup in a Row

[Anonymous]

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("top.guy@org.com",A3:J3,0)  form EXCEL, 

TIA 

[PhilipTreacy]

Hi @Anonymous 

Please read https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/td-p/1447523/jump-to/first-unread-message

Can you supply some sample data and examples of the result you want.

Regards

Phil

[Anonymous]

Sorry, First time user of this form, pardon my ignorance

Here is the sample data. I want to look up the occurance of D in the row and find the index. based on that index value i create other rules to come up with Line of business. 

[Anonymous · Accepted solution]

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

[Ashish_Mathur]

Hi,

Your data has not been pasted properly.  Share data in a format that can be pasted in an MS Excel file.  Also, please show the expected result.