Forum Discussion
object with multiple relations to other objects
Hi,
i don't have the solution yet,
first part of this article helps a lot GRAPH THEORY IN POWER BI | Blog | FreshBI
So i have the indirect relationships on my path as well
Perhaps i can describe my question in another way:
I have a table with employees and managers. This structure have several hierarchical levels.
Now i want to know when I select a manager, how many employees have birthdays today in the entire child parent hierarchy?
Is your data representing a true hierarchical tree graph or a direct acyclical graph ? Can an employee have more than one manager?
Hi lbendlin
In practice, it will come down to me that it is an acyclical model.Don't have a solution but here is an article that may interest you.
https://www.sqlservercentral.com/articles/dijkstras-algorithm