Calculate Column - Try to create an IF and AND statement

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

Need Help

Samarth_18

3 years ago

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

Idrissshatila

Super User

3 years ago

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
Frequent Visitor
3 years ago
Thank you, but sadly this didnt work.

Forum Discussion

Calculate Column - Try to create an IF and AND statement