Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
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
Hi @Anonymous
Can you supply some sample data and examples of the result you want.
Regards
Phil
Proud to be a Super User!
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.
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.
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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
100 | |
88 | |
68 | |
61 |
User | Count |
---|---|
152 | |
120 | |
102 | |
87 | |
68 |