Replacing Values

[Anonymous]

Hello, 

I am looking for help on a issue I have. 

currently I have a data set Including Staff Id, who they report to, and there full name. E.g: 

Id: 200, Reports to: 16, Name: John smith

Id: 16, Reports to: 2, Name: Joe Bloggs

However I would like to replace the "Reports to" collum (or make a new collum) to show the full name of the staff member whos id is showing in "Reports to" collum, as the "Name" collum is currently showing the name of the staff memeber in the Id collum. 

So instead  it would show:

Id: 200, Reports to: 16, Name: Joe bloggs

I could manually replace the values, however I imagine this can be quicker in DAX. 

I hope this makes sense, 

Thanks.

[tex628 · Accepted solution]

Create a calculated column:

Reporting To - Name = 
VAR id_ = 'Table'[Reports To]
return 
Calculate( SELECTEDVALUE('Table'[Name]) ;
ALL('Table');
'Table'[ID] = id_
)

 

[Anonymous]

Thanks Tex!