cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
EVEAdmin Member
Member

Display Text based on number ID

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.

 

 

Snag_4a31d5.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
chromo4130 Regular Visitor
Regular Visitor

Re: Display Text based on number ID

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.

2 REPLIES 2
chromo4130 Regular Visitor
Regular Visitor

Re: Display Text based on number ID

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.

Highlighted
EVEAdmin Member
Member

Re: Display Text based on number ID

@chromo4130 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.