Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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:
However, I'd like to learn whether that is something I can achieve dinamically, through a measure too.
Thank you.
Solved! Go to 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.
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.
@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.
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |