PATH - A table of multiple values was supplied where a single value was expected

[Anonymous]

Good Evening everyone

I want to learn how to use PATH DAX. I have a dummy table that consists of EmployeeID and ManagerID. This is the table

I want to create a calculated column that has PATH between EmployeeID and ManagerID. This is my DAX Code:

PATH = PATH(Sheet1[EmployeeID],Sheet1[ManagerID])
This is the error message that appears for this DAX Code
A table of multiple values was supplied where a single value was expected.
Why did this error happen?

Thank you very much

[lbendlin · Accepted solution]

"PATH"  is a reserved word.  Choose a different name for your calculated column.