Flatten Parent Child hierarchy with multiple months of data

[A_Vijgo]

Hi 

I have a monthly appended data for all employees and their reporting line managers changing every month. what i want to capture is the flattened out parent child hierarchy for every particular month. How can i tweak Path function or is there any other approach.

Below is the sample table and in LM1, 2 and 3, i want the hierarchy for the particular month

EID	Name	Line Manager ID	Month	LM 1	LM 2	LM 3
1036	John	2673	Oct-23
1178	Claire	2876	Oct-23
1789	Charles	2897	Oct-23
1436	Sid	2567	Oct-23
1098	Jackie	2345	Oct-23
1236	Syed	2765	Oct-23
1897	Nolan	2987	Oct-23
1036	John	2567	Nov-23
1178	Claire	2345	Nov-23
1789	Charles	2765	Nov-23
1436	Sid	2987	Nov-23
1098	Jackie	2673	Nov-23
1236	Syed	2876	Nov-23
1897	Nolan	2897	Nov-23

[v-yaningy-msft]

Hi, @A_Vijgo 

According to your description, what you are trying to capture is a flattened parent-child hierarchy for each specific month, you can refer to the link below to try to see if it solves your problem; based on the information you have given so far, it doesn't solve your problem, you can provide information about the related problem without sensitive data, including but not limited to the measure, the datasheet, the expected output results and the implementation logic of the expected output results.

Related Link: Parent-child hierarchies – DAX Patterns

If this does not work, could you please share some sample data without sensitive information and expected output.
How to provide sample data in the Power BI Forum - Microsoft Fabric Community

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum