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.
This may be pretty basic for many of you, but here is what I am trying to do.
I have a table of job requisitions and a table of job applicants. I want to lookup a value in the applicant table ([new hire]) when the [candidate status] = "Ready for Hire". The similar column between the two table is [job requisition]
I tried create a temptable:
Hi @Decal ,
LOOKUPVALUE does accept multiple lookup columns and values.
LOOKUPVALUE (
dimApplicants[new hire],
dimApplicants[job requistion], temptable[job requisition],
dimApplicants[candidate status], "Ready for Hire"
)
Proud to be a Super User!
You can always try:
Measure = CALCULATE(MIN(dimApplicants[newhire]), FILTER(RELATEDTABLE(dimApplicants),dimApplicants[candidate status]="Ready for Hire"))
just note that this doesn't handle the case where there's 2+ candidates
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 |
---|---|
104 | |
96 | |
79 | |
67 | |
62 |
User | Count |
---|---|
137 | |
106 | |
104 | |
81 | |
63 |