Calculate Column - Try to create an IF and AND statement

[Parno]

Hi although I'm not new new to PowerBI I am struggling trying to create a calculated column.  I have named the column Leaver in the same year.  I am running a data set on new starters - but also interested if they left within the same period, my attempt is below, 

Leaver in the same year = IF ((HESA Extract'[JOINER IN PERIOD] ="1"), AND (HESA Extract'[LEAVER IN PERIOD] ="1"),AND (HESA Extract'[TYPE] ="Continuing"),'Yes, No"))

Can anyone tell me where I am going wrong?

[Samarth_18]

Hi @Parno ,

You could use below code:-

Leaver in the same year =
IF (
    'HESA Extract'[JOINER IN PERIOD] = "1"
        && 'HESA Extract'[LEAVER IN PERIOD] = "1"
        && 'HESA Extract'[TYPE] = "Continuing",
    "Yes",
    "No"
)

[Parno]

Thanks for your help! really appreciated - I get the following message - any ideas?

DAX comparison operations do not support comparing values of type Integer with values of type Text. Consider using the VALUE or FORMAT function to convert one of the values.

[Samarth_18 · Accepted solution]

@Parno Please try this:-

Leaver in the same year =
IF (
    INT('HESA Extract'[JOINER IN PERIOD]) = 1
        && INT('HESA Extract'[LEAVER IN PERIOD]) = 1
        && 'HESA Extract'[TYPE] = "Continuing",
    "Yes",
    "No"
)

[Parno]

Thank you so much - you are amazing! 

[guibenassi]

@Parno take a look if there are a sintax problem.
you can try 1 of 2 of this:
Leaver in the same year = IF ((HESA Extract'[JOINER IN PERIOD] =1 && HESA Extract'[LEAVER IN PERIOD] = 1 && HESA Extract'[TYPE] ="Continuing","Yes", "No"))
Leaver in the same year = IF ((HESA Extract'[JOINER IN PERIOD] ="1" && HESA Extract'[LEAVER IN PERIOD] = 1 && HESA Extract'[TYPE] ="Continuing","Yes", "No"))

[Parno]

Thank you, but of these show the result as #ERROR

[Idrissshatila]

Hello @Parno ,

try this

Leaver in the same year = IF ((HESA Extract'[JOINER IN PERIOD] =1 && HESA Extract'[LEAVER IN PERIOD] = 1 && HESA Extract'[TYPE] ="Continuing",'Yes", "No"))

If I answered your question, please mark my post as solution so it would appeare to others, Appreciate your Kudos 👍

Follow me on Linkedin

[Parno]

Thank you, but sadly this didnt work.