Hierachical information

[cvo]

Hi,

have a look to this post

Building Org Structure - Parent_Child Structure

Hi Dmitry Can anyone direct me on how to build a structure similar to using Path, Pathlength and as in PowerBi? Path = PATH(DimEmployee[EmployeeKey],DimEmployee[ParentEmployeeKey]) Path Length = PATHLENGTH(DimEmployee[Path]) Organization Level 1 = PATHITEM( DimEmployee[Path], 1, 1) Thanks Rykie

Regards