Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
consider the following table
ID Name ManagerID ManagerName(column to be created)
1 X 102 Y
102 Y 201
I need to create a new column "Manager Name", where it searches the table for ID corresponding to Manager ID and prints out the Name from the searched row .
new to PBI..need a DAX function for this
Solved! Go to Solution.
Manager Name =
var nameValue= LOOKUPVALUE(Role[Name],Role[ID],Role[Manager ID])
return nameValue
Table Name: Role
If this is working for you, please mark this answer as a solution.
Regards,
Nandu Krishna
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
46 | |
28 | |
22 | |
12 | |
8 |
User | Count |
---|---|
75 | |
52 | |
46 | |
15 | |
12 |