Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Path Function with multiple classification/grouping

Hi,   I am currently working on Org Structure data with Parent-Child heirarchy. My data consists of multiple companies and I want to build Path functions on it. example PATH, PATHITEM etc   Sampl...
Need Help
Show and Tell
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , Create combine columns and try

     

    Employee_Code = [Company_id] & "-" & [Employee_ID]

    SupervisorCode = [Company_id] & "-" & [Supervisor_id]

     

     

    or try a new column like  , I have not tested this

    calculate(PATH(Data[Employee_Id],Data[Supervisor_Id]), filter(Data, Data[Company_id] = earlier(Data[Company_id])))

amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , Create combine columns and try

 

Employee_Code = [Company_id] & "-" & [Employee_ID]

SupervisorCode = [Company_id] & "-" & [Supervisor_id]

 

 

or try a new column like  , I have not tested this

calculate(PATH(Data[Employee_Id],Data[Supervisor_Id]), filter(Data, Data[Company_id] = earlier(Data[Company_id])))

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thanks amitchandak, The formula did not work but the concatenation did.