MS Project Data Source: Translating Task.PathDrivingPredecessor from VBA to Power Query (??!!)

[maibacherstr]

Hello PBI Community,

A Schedule Manager brought to my attention that MS Project has a little known feature called Task.PathDrivingPredecessor, which shows a lineage of predecessors tasks ("drivers") leading to a given successor. Based on the documentation (link below), this function only returns true/false at the row level, which is used for color coding MS Project's Gantt chart. It does not make itself available as a column. The documentation also includes VBA code.

Task.PathDrivingPredecessor property (Project) | Microsoft Docs

My question is, has this function ever been hashed out in Power Query? If so, it would provide the basis for a powerful visualization to answer the question, "what tasks impact this task?" 

Please note, the *lineage* is crucial. My report already breaks out a view of immediately predecessors and successors, but is unable to show lineage as though peeling back additional layers.

Thanks very much for any insight into this.

[v-yingjl]

Hi @maibacherstr ,

As far as I know, there seems no same function which equals to Task.PathDrivingPredecessor in Power Query currently.

Perhaps you can submit the requirement to ideas and add your comments there to make this feature coming sooner: https://ideas.powerbi.com/forums/265200-power-bi-ideas

It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.