Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
User | Count |
---|---|
57 | |
22 | |
21 | |
19 | |
16 |
User | Count |
---|---|
87 | |
87 | |
52 | |
37 | |
23 |