Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Sample
Company_id Employee_id Supervisor_id
a 1
a 2 1
a 3 1
a 4 2
b 1
b 2 1
b 3 1
Bu thtese functions need unique identifier. Is there a way I can group these items by Company and run the path functions as new columns on them Tried the below dax function but it thre me an error
Solved! Go to Solution.
@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])))
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |