Uso de Filtro dentro de la función Interruptor

[fernandoC]

¡Hola!

Actualmente estoy buscando una manera de usar la función Filtro dentro de una fórmula Switch. Actualmente utilizo el siguiente:

Status Name Complete = 
SWITCH('Main Jira Info Prod'[Status Name], " Contact Candidate","Contacted",
" New Candidate","Contacted",
" CV Review","Contacted",
" Pre-screen Decision","Screening",
" New Interview","HR Interview",
" HR Interview","HR Interview",
" Requested for Technical Interview","Technical Interview",
" Technical Interview","Technical Interview",
" Technical Interview finished","Technical Inteview",
" Requested for Final Interview","Final Interview",
" Final Interview","Final Interview",
" Final Interview finished","Final Interview",
" Interview Decision","Final Interview",
" New offer","Offer",
" Approved offer","Offer",
" Offer in progress","Offer",
" Redo Offer", "Offer",
" Offer Done", "Hires",
BLANK()
)

El problema que he estado teniendo es que en el último "Oferta hecha" tengo que especificar que la columna tiene el valor "Oferta hecha" pero también que la columna 'Resolución de oferta' tiene el valor 'Aceptado' para que cambie a 'Contratar' y si el valor es 'Declinado' debe permanecer como 'Oferta.

¿Alguna sugerencia?.

Mejor

[amitchandak · Accepted solution]

@fernandoC , Cambiarlo Cambiar verdadero, Pero eso significa que ha dado condiciones ejemplo

Status Name Complete = 
SWITCH( true () ,
'Main Jira Info Prod'[Status Name]= " Contact Candidate","Contacted",
'Main Jira Info Prod'[Status Name]= " New Candidate","Contacted",
'Main Jira Info Prod'[Status Name]= " CV Review","Contacted",
'Main Jira Info Prod'[Status Name]= " Pre-screen Decision","Screening",
'Main Jira Info Prod'[Status Name]= " New Interview","HR Interview",
'Main Jira Info Prod'[Status Name]= " HR Interview","HR Interview",
'Main Jira Info Prod'[Status Name]= " Requested for Technical Interview","Technical Interview",
'Main Jira Info Prod'[Status Name]= " Technical Interview","Technical Interview",
'Main Jira Info Prod'[Status Name]= " Technical Interview finished","Technical Inteview",
'Main Jira Info Prod'[Status Name]= " Requested for Final Interview","Final Interview",
'Main Jira Info Prod'[Status Name]= " Final Interview","Final Interview",
'Main Jira Info Prod'[Status Name]= " Final Interview finished","Final Interview",
'Main Jira Info Prod'[Status Name]= " Interview Decision","Final Interview",
'Main Jira Info Prod'[Status Name]= " New offer","Offer",
'Main Jira Info Prod'[Status Name]= " Approved offer","Offer",
'Main Jira Info Prod'[Status Name]= " Offer in progress","Offer",
'Main Jira Info Prod'[Status Name]= " Redo Offer", "Offer",
'Main Jira Info Prod'[Status Name]= " Offer Done" && 'Main Jira Info Prod'[Offer Resolution] = "Accepted", "Hires" ,
BLANK()
)

[fernandoC]

¡Eso funciona como un encanto!.

Gracias @amitchandak .