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"
)
guibenassi's avatar
guibenassi
Icon for Advocate II rankAdvocate II
3 years ago

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's avatar
    Parno
    Frequent Visitor
    3 years ago

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