Forum Discussion

Hadill's avatar
Hadill
Icon for Helper I rankHelper I
4 years ago
Solved

If-else-else Error

I tried many ways to write the If- else quiery, and ever time I get the same error an I dont know the reason, I think I apply the right quirey. Is anybody have any explanation for that?   Thanks i...
Interesting Links
  • BA_Pete's avatar
    BA_Pete
    4 years ago

    Hi Hadill ,

     

    Try pasting this into a new custom column window:

    if [Funnel Status] = "Booked" or [Funnel Status] = "Signed" or [Funnel Status] = "Committed" then "Forecast" else "Active"

     

    Pete

BA_Pete's avatar
BA_Pete
Icon for Super User rankSuper User
4 years ago

Hi Hadill ,

 

Can you post the code as it appears now after the changes please?

 

Pete

Hadill's avatar
Hadill
Icon for Helper I rankHelper I
4 years ago

Hi BA_Pete 

 

here we are, I tried to change the code body.

I was wondering if there any thing have to be done with the settings to enable this case?

 

 

  • BA_Pete's avatar
    BA_Pete
    Icon for Super User rankSuper User
    4 years ago

    Hi Hadill ,

     

    Try pasting this into a new custom column window:

    if [Funnel Status] = "Booked" or [Funnel Status] = "Signed" or [Funnel Status] = "Committed" then "Forecast" else "Active"

     

    Pete

    • Hadill's avatar
      Hadill
      Icon for Helper I rankHelper I
      4 years ago

      Hello BA_Pete 

       

      Thanks a lot for your support, I tried to apply the SWITCH function insted, and it works perfectly ! 

      I added a coulomn in DAX query edit as follow :

       

      Forecast vs Active = SWITCH( TRUE(), [Wrong Funnel Status] = "Booked" || [Wrong Funnel Status] = "Signed" || [Wrong Funnel Status] = "Committed", "Forcasted", "Active")