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,
If the final status of each candidate = offered role, then Recruiter ideal result column should be= The recruiter relevant for offered role status.
Hope this is clear. Appreciate your help.
Candidate Name | Status | Recruiter Full Name | Timestamp | Recruiter ideal result |
Candidate 1 | New | PB | 01/01/2020 | KW |
Candidate 1 | Phone screened | KW | 05/01/2020 | KW |
Candidate 1 | Interview complete | PB | 24/01/2020 | KW |
Candidate 1 | Offered role | KW | 22/02/2020 | KW |
|
|
|
|
|
Candidate 2 | New | PB | 01/03/2020 | PB |
Candidate 2 | Phone screened | KW | 07/03/2020 | PB |
Candidate 2 | Interview complete | PB | 21/04/2020 | PB |
Candidate 2 | Offered role | PB | 27/05/2020 | PB |
Solved! Go to Solution.
Thank you all
@wdx223_Daniel , Try a new column
maxx(filter(table, [Candidate] = earlier([Candidate]) && [Status] = "Offered role"),[Recruiter Full Name])
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 |
---|---|
42 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
39 | |
33 | |
18 | |
17 |