IFS and AND

Hey ameera_williams ,

try the following calculated column:

My IFS Column =
SWITCH (
    TRUE (),
    myTable[% Completed vs Planned] > 0.5 && myTable[% Completed vs Planned] < 0.89, "At Risk",
    myTable[% Completed vs Planned] > 0.9, "On Target",
    myTable[% Completed vs Planned] <= 0.5, "Off Target"
)

You can check for multiple criteria the best with the combination of SWITCH and TRUE. Check also the following article for that:

https://powerpivotpro.com/2015/03/the-diabolical-genius-of-switch-true/