Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowJuly 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more
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
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
Join Fabric Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.
| User | Count |
|---|---|
| 23 | |
| 22 | |
| 18 | |
| 17 | |
| 13 |
| User | Count |
|---|---|
| 63 | |
| 44 | |
| 42 | |
| 40 | |
| 39 |