Path Function - Filter Multiple Parent ID's based on date range

[a_guest1005]

HI,

I've read numerous posts and can't seem to find anything that solves this, so thought I'd ask.

I've an employee table, holding line mgr information and changes to this line mgt /  employee data over time.
The current record is marked by an IsCurrent Column

What I need to do:
When the path function comes across two records, it looks at the records that is current.

Or if I apply a date filte to my visual, I return the line management at that point in time.

So prior to End of July I have one Hierarchy and after this I get a different one for the employees shown below.

Is this possible?

TIA

[amitchandak]

@a_guest1005 , refer if this can help

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

[a_guest1005]

Thanks for sharing. I like what it achieves and will help with other reporting I need to do.

However, it doesn't solve my hierarchy (line Mangement) issue above.