Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 |
Solved! Go to 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())
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
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())
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |