Forum Discussion
Ability to filter downstream dependancies
Hi
I have a table that shows project dependancies. The requirement is to be able to identify and visualize the downstream dependancies for any selected Node.
Filtering (e.g. on Project D) unfortunately will only show one level down (i.e. ProjectC) and the requirement is to show all downstream dependancies (a,b and c) by way of a network diagram, table or gantt. I thought the PATH and related functions could assist, however see that they only work for natural hierarchies.
Any suggestions and advice would be much appreciated
Thanks Doug
2 Replies
- v-chuncz-msftCommunity Support
Anonymous,
According to your description above, I wonder if you could use Power Query to generate a table that contains all the related rows.
- AnonymousNot applicable
Thanks Sam, appreciated. I am not sure how to go about it, but will consider it
Regards
Doug