Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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())
User | Count |
---|---|
86 | |
82 | |
68 | |
64 | |
55 |
User | Count |
---|---|
120 | |
99 | |
91 | |
83 | |
65 |