Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I’m looking for a way to show a chain of predecessors and successors for every task.
It means I need to find dependent tasks to finally see the impact of slacks on projects.
I've prepared a sample data that shows the Output.
In this table, there is a Predecessors Column that contains a list of task indexes that should be done before the task in each row.
The Successors column is a list of tasks that should be done after the task in each row.
It is possible every predecessor index has its own predecessors in its row. In result we have a chain of related tasks.
One of the problems is, indexes are not unique and for retrieving Id (That is unique) I need to check ProjectId as well. ProjectId of the index = ProjectId of predecessors in their rows.
The question is: for each task that I select in another page shows the chain of related tasks like the output in the excel file.
I’m not sure whether using DAX is better or M. But is my second problem. Also, have no idea that output should be a list or record or table for each task?
I would appreciate it if you help me and guide me to solve the problem.
Thanks for taking time in advance.
Id | Index | ProjectId | Predecessors | Successors |
101 | 1 | 60 | 2 | |
102 | 2 | 60 | 1,7 | |
103 | 3 | 60 | 8 | |
104 | 1 | 22 | 2,6 | |
105 | 2 | 22 | 1 | |
106 | 5 | 22 | 2 | |
107 | 6 | 22 | 6 | |
108 | 6 | 60 | 2 | |
109 | 7 | 60 | 8 | |
110 | 8 | 60 | 7 |
@Anonymous
Try:
MAXX(FILTER(allselected('Dependency'), 'Dependency'[Index] = in values([_Predecessors] && [ProjectId] = max([_ProjectId]),Dependency[TaskId]))
One thing I am not sure is what are _Predecessors and _ProjectId, are they variables, measures or columns?
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
Thanks. _Predecessors is a variable.
But Still not working.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.