RELATED function not working in one to many relationship

[Anonymous]

HI ALL

I have two Tables  Registration Table and Interview Result Table. 

I want to create two columns (Final Status, Interview Completed?) in the Registration Table by using Interview Result Table value

How can I achieve this logic?

Registration Table:

Candidate ID Name Phone

1	A	5555555
2	B	6666666
3	C	7777777
4	D	888888
5	E	999999

Interview Result Table :

Candidate ID Interview Round Status Final Status

1	Tech 1	Selected	Selected
1	Tech 2	Selected	Selected
1	HR	Selected	Selected
1	Final	Selected	Selected
2	Tech 1	Selected	Rejected
2	Tech 2	Selected	Rejected
2	HR	Selected	Rejected
2	Final	Rejected	Rejected
3	Tech 1	Selected	Hold
3	Tech 2	Selected	Hold
3	HR	Hold	Hold

Final Result:

Candidate ID Name Phone Final Status Interview Completed?

1	A	5555555	Selected	Yes
2	B	6666666	Rejected	Yes
3	C	7777777	Rejected	Yes
4	D	888888		No
5	E	999999		No

[JoelN]

Nicely done @Stachu 👍

[Iryna]

Hello,

In my case it doesn't work 😞 Or I do something wrong. I have just started working with Power BI.
I would like do do a kind of VLOOKUP in order to assingn values from the table "one" to the table "many". So the values will be repeating in the new column of the table "many".

Thanks,
Iryna

[Stachu · Accepted solution]

RELATED works only for side 1 of the relationship, for side many you need to use RELATEDTABLE

Column = LASTNONBLANK(SELECTCOLUMNS(RELATEDTABLE('Interview Result'),"Status",[Final Status]),TRUE())