Forum Discussion
Helper ILookup Multiple users details found in one column using another table
Hello,
I have two tables that looks like this
Task Table
| EmpID | TaskNumber | UpdatedBy | TaskManager |
| 1vv,2vv | 3452 | 5vv | 5vv |
| 3ve | 324 | 5vv | 5vv |
| 3vv,3ve | 238 | 6vv | 5vv,6vv |
Users Table:
| UserID | Name |
| 1vv | Username1 |
| 3ve | Username2 |
| 3vv | Username3 |
| 2vv | Username4 |
| 3ve | Username5 |
| 5vv | Username6 |
| 6vv | Username7 |
-Task Report table is containing all the tasks and users/employees working on it so two users can work on the same task
-Users Table: Containing all the users/employees details
I need to replace the IDs that are in the Task Report table by its matching name in the Users table
Expected results will be like this
Im not sure how to move forward with this and appreciate any tips.
Thank you!
Hi SamOvermars ,
My understanding is that you want to match the id of the two tables, and the easiest way to do that is to create a relationship between the two tables:
This also establishes the relationship between the id in the task table and the username in the user table, then you can achieve what you want, like this:
If I misunderstand your meanings , please let me know in time. Thanks in advance~
Best regards,
Community Support Team Selina zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
3 Replies
- Greg_Deckler
Community Champion
SamOvermars Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
SamOvermarsI changed the post hopefully its much clearer now. Thanks!
Hi SamOvermars ,
My understanding is that you want to match the id of the two tables, and the easiest way to do that is to create a relationship between the two tables:
This also establishes the relationship between the id in the task table and the username in the user table, then you can achieve what you want, like this:
If I misunderstand your meanings , please let me know in time. Thanks in advance~
Best regards,
Community Support Team Selina zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
