Forum Discussion
Helper ILookup Multiple users details found in one column using another table
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
Community ChampionSamOvermars 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.
Helper II changed the post hopefully its much clearer now. Thanks!