Hey all, I have a table containing an employee's name, their phone number, and their manager's name. Knowing that the manager's name and phone number are listed where they are listed as employees, I want to add a column containing manager phone numbers. What would be the easiest way to go about this? Stay well all.

Hope that this will help. Generally, you need 2 tables, one containing just Employee/Mngr and Phone columns that you have. The second is containing Employee, Phone, Manager and you need to create new calculated column to lookup this phone next to the manager

Adding Manager Phone from Employee table | Microsoft Fabric Community

Forum Discussion

Related content

Adding managers as employee in employee table

Recursive Hierarchy; Managers and Employees

Counting Active employees per month

Missing employee

Employee Manager Hierarchy