Manage relationship - connect one value in table A with two values in table B

[PhEhle]

Hi everyone,

I need to solve following problem:

I only get one relationship with the result that I only get the [requested by] OR [todo for] name in the output table but not both.

I suspect it´s a super-simple solution, but I don´t get it.

Greetings, Philip

[negi007 · Accepted solution]

@PhEhle 

here is the solution that can be used here

in this case you can create two calc columns in the second table to extract name of the employee

using lookupvalue function, we can have the name of the employee based on the ID value

Req_Name = LOOKUPVALUE('Table'[Name],'Table'[ID],'Table (2)'[requestedBy])

Todo_Name = LOOKUPVALUE('Table'[Name],'Table'[ID],'Table (2)'[todo for])

i am attaching pbix file for your reference as well

[PhEhle]

many thanks to negi007 for the quick answer. 

This solved my problem in an easy way.