Forum Discussion
Find the main value
Hello everyone I have a table called "Project", the unique key is a 6-digit project number, column name "ProjectNumber". Each project can be part of a larger project, so I have a "ParentProject" ...
This sounds like a job for the PATH() function. Please see this blog post on how to use it. The example is for employee/supervisor but it can be applied whenever you have a parent/child column relationship.
https://powerpivotpro.com/2017/12/imagine-people-tables/
If this works for you, please mark it as the solution. Kudos are great too. Please let me know if it doesn't or if any questions.
Regards,
Pat