Forum Discussion
Dynamic Permissions with Active Directory User Hierarchy Management
- 2 years ago
Seems to work fine
You are not trying to do that as a measure, right? Needs to be a calculated column.
read about PATH and PATHCONTAINS
- jsanborn2 years agoFrequent Visitor
I have read about the PATH functions but none of them work. I get an error each time (command misspelled...). I have a basic test setup with two numeric columns and one name column. Each time I use this syntax "Path = PATH('Employees'[employeeID],'Employees'[managerID])" or "Path = PATH([employeeID],[managerID])" it errors out.
- lbendlin2 years ago
Super User
Path = PATH('Employees'[employeeID],'Employees'[managerID])is correct. Any errors you see will be caused by data quality issues (managerID values missing in the employeeID column).
- jsanborn2 years agoFrequent Visitor
This is as basic as it gets, 3 columns with numbers and text only.
employeeID employeeName managerID
1 John 5
2 Bill 10
3 Joe 5
4 Mary 5
5 Jennifer 10
6 Robert 8
7 Renee 8
8 Paul 10
9 Peter 10
10 Wendy