Forum Discussion

Parno's avatar
Parno
Frequent Visitor
3 years ago
Solved

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's avatar
    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"
)
Samarth_18's avatar
Samarth_18
Icon for Community Champion rankCommunity Champion
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"
)
Parno's avatar
Parno
Frequent Visitor
3 years ago

Thank you so much - you are amazing!