Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I am trying to make a task list with substasks and would like so show status on the subtasks on the main task.
An example is shown below, task 3 and 4 is a subtask for task 2, task 6 is a subtask for task 5.
How can I show status of subtasks in main task? (I've tried LOOKUPVALUE without any success so far).
Any ideas? Thanks!
-A-
Solved! Go to Solution.
Hi @Peavey ,
Here are the steps you can follow:
1. Create calculated column.
Column =
CONCATENATEX(
FILTER(ALL('Table'),
'Table'[Subtask for main task]=EARLIER('Table'[Task id])),
[Status],",")
2. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi @Peavey ,
Here are the steps you can follow:
1. Create calculated column.
Column =
CONCATENATEX(
FILTER(ALL('Table'),
'Table'[Subtask for main task]=EARLIER('Table'[Task id])),
[Status],",")
2. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Thanks! Great solution, it worked fine for me 😀
A follow up request, how can I add a colum that is true/false it a task has a open subtask? This to have visuals to highlight that a task has subtasks that are open, not only the status.
Thanks,
-A-