Forum Discussion
Need help with Hierarcy PathItem in Calculated Table
Hi, everyone. I am working on data from Dynamics 365. The example below is a simplification. I have a Users table with their Manager (ReportsTo). I then have a Sales table. When a user logs into ...
v-huizhn-msft
Microsoft Employee
Microsoft EmployeeHi Anonymous,
PATHCONTAINS function is used to create a calculated column. Please create a calculated column in 'Sales' table and check if it is right.
Please refer to the following threads for more details.
Manager Level Hierarchies with multiples in Power BI
Creating a user hierarchy from a manager column to use as hierarchy slicer
Power BI Tutorial: Flatten Parent Child Hierarchy
Best Regards,
Angelia