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.
Hi All,
Hoping this is fairly simple. I have single table as shown below (real table has 1000's of rows)
I'm not interested in "Manager ID". I want manager name as per below.
Any suggestions? The logic is something along the lines of
Thanks
Solved! Go to Solution.
hi, @quinla01
You could use LOOKUPVALUE Function to create a calculate column as below:
Manager = IF(ISBLANK('Table'[Manager ID])=FALSE(),LOOKUPVALUE('Table'[Employee],'Table'[ID],'Table'[Manager ID]))
Result:
Best Regards,
Lin
hi, @quinla01
You could use LOOKUPVALUE Function to create a calculate column as below:
Manager = IF(ISBLANK('Table'[Manager ID])=FALSE(),LOOKUPVALUE('Table'[Employee],'Table'[ID],'Table'[Manager ID]))
Result:
Best Regards,
Lin
That worked a charm. Many Thanks.
Out of interest, do you know how this would be done from the query editor rather than in report view?
Thanks
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 |
---|---|
109 | |
96 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |