Forum Discussion
Multiple parents hierarchy - Find longest path
Here's the PBIX with both shortest and longest path
Here's a more contemporary implementation in SQL. Should be possible to convert that into Power Query.
Here is the PBIX file with your data and the algorithm you mentioned. The algorithm calculates the shortest path, not the longest path.
Here's the PBIX with both shortest and longest path
Super thanks! I've done multiple checks and it works as expected.
Thank you very much for the effort.
PS: To give some context, I needed it in order to calculate a gantt with multiple parent hierarchy. In that gantt I have a start time of the first installation but not for the others. Then for the other's start time I needed to calculate the most far away date, that is exacly where it will start that installation. And so on.
