Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Correcting Errors in PATH

Hello All,      I am using the PATH statement to create a 'chain of command'.   PATH = PATH(Results[Full Name],Results[Reports to])   Due to the volume of employees and turn over; there are a...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    5 years ago

    Hi Anonymous , I suggest adding a column and replace the names that don't appear in Full Name column with your CEO's name. Then use this column in your PATH statement instead of the original Reports to column.

     

    Example:

    Reports to (Backup) = LOOKUPVALUE('Employees'[Full Name],'Employees'[Full Name],'Employees'[Reports to],"Tomas")

Path = PATH('Employees'[Full Name],'Employees'[Reports to (Backup)])

    Best Regards,

    Community Support Team _ Jing Zhang

    If this post helps, please consider Accept it as the solution to help other members find it.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hello If have tried the IFERROR and it does not work on the PATH statement:

 

PATH = IFERROR(PATH(Results[Full Name],Results[Reports to]),"Justin")
 
Still yeilds #ERROR in alll values for the column. I also get an error
 
"The value 'KristenD' in [Reports to] does not appear in [Full Name]. Please add the missing data".
 
This makes sense as Kristen was terminated, but the 30 people that she had reporting to her, have not changed. 
 
Cheers,
 
Peter
v-jingzhang's avatar
v-jingzhang
Icon for Community Support rankCommunity Support
5 years ago

Hi Anonymous , I suggest adding a column and replace the names that don't appear in Full Name column with your CEO's name. Then use this column in your PATH statement instead of the original Reports to column.

 

Example:

Reports to (Backup) = LOOKUPVALUE('Employees'[Full Name],'Employees'[Full Name],'Employees'[Reports to],"Tomas")

Path = PATH('Employees'[Full Name],'Employees'[Reports to (Backup)])

Best Regards,

Community Support Team _ Jing Zhang

If this post helps, please consider Accept it as the solution to help other members find it.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    That Worked!

     

    Thank You!