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. I would like to create a calculated column which takes 2-3 statuses and merge them into one. I've been using Switch or IF functions but I can't seem to find the right formula for this. 

 

Example: 

 

Status NameStatus Name Goal
Contact CandidateContacted 

Screening 

Contacted
HR InterviewHR 
Schedule HR InterviewHR

 

Thanks!!

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

3 Replies

  • 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.