Forum Discussion

Anonymous

Not applicable

8 years ago

Solved

Work Breakdown Structure in Table Form

Hi There, I have data for projects and project tasks at varying work breakdown levels. e.g. One project may only have 2 levels Task 1 -> Task 1.1, Task 1.2, etc. while another project has many ...

Need Help

Anonymous
8 years ago
Hi I ended up finding helpful resources, see below.

https://community.powerbi.com/t5/Desktop/Path-and-Matrix/td-p/437109
https://www.daxpatterns.com/parent-child-hierarchies/

Thanks for your help Stachu

Stachu

Community Champion

8 years ago

you will need to use PATH
https://msdn.microsoft.com/en-us/query-bi/dax/understanding-functions-for-parent-child-hierarchies-in-dax

https://msdn.microsoft.com/en-us/query-bi/dax/path-function-dax

Forum Discussion

Work Breakdown Structure in Table Form

Related content

Table structure

Sum Breakdown

ELT JSON / Semi structured

ELT JSON Semi Structured Loop

Creating custom columns keeps returning a structured Table column