Lookup Multiple users details found in one column using another table

[SamOvermars]

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!

[v-mengzhu-msft · Accepted solution]

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

[Greg_Deckler]

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

[SamOvermars]

I changed the post hopefully its much clearer now. Thanks!