Forum Discussion

actzikas's avatar
actzikas
Frequent Visitor
6 years ago
Solved

IF ELSE Statement for Column

I am trying to create an If Statement to create/group a column in the following order.  If Probability < 50 then it is "Early"  If Probability >= 50 or < 75 then it is "Warm"  If Probability is ...
Need Help
  • az38's avatar
    az38
    6 years ago

    Hi actzikas 

    i dont think you need the last statement 

    IF(Opportunity[Probability] >= 75, "Late"

    because you have already described any of possible values.

    so, you could leave just

    Piepline Probability Stage = IF(Opportunity[Probability] < 50, "Early", IF(Opportunity[Probability] >= 50 || Opportunity[Probability] < 75, "Warm", "Late"))
dax's avatar
dax
Icon for Community Support rankCommunity Support
6 years ago

Hi actzikas,

If you want to create calculated column, you could try to follow above suggestions. Or you also could use below expression 

Column = SWITCH(TRUE(),'Table'[Column1]<50, "a", 'Table'[Column1]<75, "b", 'Table'[Column1]>=75 ,"c")

 

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.