Display Text based on number ID

[EVEAdmin]

Hi all,

in the the table below, there is a field corresponding to the Employee ID. In my report, I would like to display the employee name instead of the ID. My options are:

• add a calculated column
• extract the name from the SQL data source

However, I'd like to learn whether that is something I can achieve dinamically, through a measure too.

Thank you.

[Anonymous · Accepted solution]

I guess you have an employee table with unique values, right?...if that is the escenario, make a relationship between the employee table (or whereever you have the employee names as unique) and the table you only have employee ID... after that you will be able to use the name column from that table everywhere in your model.

[EVEAdmin]

@Anonymous thank you, appreciated.
I did not have that table but I do now. So simple, I just created. The solution will also serve for other similar situations.