Forum Discussion
Hierarchy - Column
Epic = Grand Parent, Task = Parent and Sub-task = child. I need help. I am newbie and trying to create a new column("Total Hours") that will show the sum of Sub-task hours to epic row. See e...
Hi Sakamoto_S ,
You need to follow a Hierarchy parent-child setup.
Check the SQLBI post about a similar setup.
https://www.daxpatterns.com/parent-child-hierarchies/
Believe that the only question here is the fact that you have the total hours in task and in subtasks.