Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
According to your description above, I wonder if you could use Power Query to generate a table that contains all the related rows.
Thanks Sam, appreciated. I am not sure how to go about it, but will consider it
Regards
Doug
User | Count |
---|---|
14 | |
4 | |
2 | |
1 | |
1 |
User | Count |
---|---|
21 | |
3 | |
2 | |
2 | |
2 |