Lookup table doubles as fact table

Hi Anonymous ,

According to your description—— In order to find the name of the manager I have to take the manager's user ID and look it up against same Users table. 

It seems that userID , managerName are in the same table, so the data table may be like:

If you want a managerID column:

Column = LOOKUPVALUE('Table'[userID],'Table'[userName],[managerName])

Or you want a manager table:

Manager Table = ADDCOLUMNS( VALUES('Table'[managerName]),"managerID",LOOKUPVALUE('Table'[userID],'Table'[userName],[managerName]))

Or if you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.

Refer to:

How to Get Your Question Answered Quickly - Microsoft Power BI Community

How to provide sample data in the Power BI Forum - Microsoft Power BI Community

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.