Forum Discussion

fernandoC's avatar
fernandoC
Helper V
5 years ago
Solved

Help with Calculated Column

Hi!   I have a column with all the statuses of a process, the main goal is to use that information to create the stages of a funnel, however, there's too many statuses which would lead to confusion...
Need Help
Show and Tell
Tips and Tricks
  • Greg_Deckler's avatar
    Greg_Deckler
    5 years ago

    fernandoC Should be something like:

    Status Name Goal =
  SWITCH([Status Name],
    "Contact Candidate","Contacted",
    "Screening","Contacted",
    "HR Interview","HR",
    "Schedule HR Interview","HR"
  )
Greg_Deckler's avatar
Greg_Deckler
Community Champion
5 years ago

fernandoC Should be something like:

Status Name Goal =
  SWITCH([Status Name],
    "Contact Candidate","Contacted",
    "Screening","Contacted",
    "HR Interview","HR",
    "Schedule HR Interview","HR"
  )
  • fernandoC's avatar
    fernandoC
    Helper V
    5 years ago

    Hi Greg_Deckler ,

    I've used your example and DAX doesn't show any errors but the column is empty for some reason:

     

    Status Name Complete =
    SWITCH('Main Jira Info'[Status Name], "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",
    "Interview Decision","Final Interview",
    "New Offer","Offer",
    "Approved Offer","Offer",
    "Offer in Progress","Offer",
    "Offer done", "Hired",
    BLANK()
    )
    Any idea why??
    Thanks for your help. 
     
    Best, 
    • fernandoC's avatar
      fernandoC
      Helper V
      5 years ago

      Hi Greg_Deckler ,

       

      Nevermind! as I previously splitted that column there was a space at the beginning of the status name which cause the issue. 

       

      Thanks again your formula worked like a charm.

       

      Best, 

       

      Fc.