Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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])))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |