Forum Discussion
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...
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 , 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])))
Thanks amitchandak, The formula did not work but the concatenation did.