Using Filter within Switch function

[fernandoC]

Hi!

I'm currently looking for a way to use the Filter function within a Switch formula. Currently I use the following one:

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()
)

The problem I've been having is that on the last one "Offer Done" I need to specify that the column has the value 'Offer Done' but also that the column 'Offer Resolution' has the value 'Accepted' so that it switches to 'Hires' and if the value is 'Declined' it should stay as 'Offer. 

Any suggestions?. 

Best, 

[amitchandak · Accepted solution]

@fernandoC , Change it Switch True, But that means you have given conditions example

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]

That works like a charm!.

Thank you @amitchandak .