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
Go to Solution.
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]))
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?
Power BI Super User, Greg Deckler, explains
Register by September 5 to save $200
Engage and empower students with Power BI!
Continue your learning in our online communities.