If-else-else Error

[Hadill]

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 in advance

[Hadill]

Hello BA, thanks for your reply !

I fixed my queiry as per your comments, but I still have the same issue. 

[BA_Pete]

Hi @Hadill ,

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

Pete

[Hadill]

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 · Accepted solution]

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]

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

[BA_Pete]

Hi @Hadill ,

Try making the following changes to remove the error:

1) Make sure that your third reference to [Funnel Status] is spelt correctly.

2) Make sure there is a space between "Committed" and 'and'

3) Make sure the keyword 'if' is lower case

4) Remove the semicolon ';' at the end

I also think you will need to correct your evaluation as a single field can't be "Booked" AND "Committed" AND "Signed" all at the same time - you may need the OR operator here.

Pete