To prepare for this recipe, do the following:
- Open Power BI Desktop.
- Use an Enter Data query to create a table called R06_Table with the following data:
|
Candidate |
Interviewer1 |
Interviewer2 |
|
A |
1 |
1 |
|
B |
2 |
2 |
|
C |
3 |
3 |
|
D |
4 |
3 |
|
E |
5 |
6 |
|
F |
6 |
5 |
|
G |
7 |
8 |
|
H |
8 |
7 |
|
I |
9 |
10 |
|
J |
10 |
9 |
|
K |
11 |
12 |
|
L |
12 |
11 |
The data in the R06_Table table represents two interviewers' rankings of candidates for a job. The Candidate column is simply for reference and is not critical to the recipe.
It is critical to the functioning of this recipe that the first interviewer's rankings are sorted in order from lowest to highest.