Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello everyone
In the organization I work for, an employee can move from one manager to another manager in some period of time, so I need to find a solution that will allow creating a new hierarchy path based on a date. Is it possible?
here is an example:
Date | ManagerId | Person Id |
01/01/2022 | 1 | |
01/01/2022 | 1 | 2 |
01/01/2022 | 1 | 3 |
01/01/2022 | 2 | 4 |
02/01/2022 | 3 | 4 |
for this scenario, I would except to get that path:
Path | Date | ManagerId | Person Id |
1 | 01/01/2022 | 1 | |
1|2 | 01/01/2022 | 1 | 2 |
1|3 | 01/01/2022 | 1 | 3 |
1|2|4 | 01/01/2022 | 2 | 4 |
1|3|4 | 02/01/2022 | 3 | 4 |
The path function doesnt let me build a path because some of my values got more than one parent, like person id '4' in this example.
Thank You.
Hey @Ofiro1234 ,
you can't create this for a simple reason: it's not possible that a child has multiple parents.
Regards,
Tom
Thank you for your response.
do you know if there is any other solution for this scenario? maybe without the path function.
Hello did you find a solution? I have the same problem. Some employees belong to 2 different departments so they have 2 managers so they have duplicated values in my table.
Thank you
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
66 | |
34 | |
25 | |
22 |
User | Count |
---|---|
97 | |
96 | |
58 | |
45 | |
42 |