Forum Discussion
object with multiple relations to other objects
Hi, i have a table "Object"with unique ID. They have a relation to other object with is defined in a seperate table "Relations" now i want to make insigts how the object are related to each ot...
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?