Forum Discussion
RELATED function not working in one to many relationship
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 |
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())
3 Replies
- Stachu
Community Champion
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()) 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
