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.
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.
Solved! Go to Solution.
Create a calculated column:
Reporting To - Name =
VAR id_ = 'Table'[Reports To]
return
Calculate( SELECTEDVALUE('Table'[Name]) ;
ALL('Table');
'Table'[ID] = id_
)
Create a calculated column:
Reporting To - Name =
VAR id_ = 'Table'[Reports To]
return
Calculate( SELECTEDVALUE('Table'[Name]) ;
ALL('Table');
'Table'[ID] = id_
)
Thanks Tex!
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 |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |