Forum Discussion

rocky09's avatar
rocky09
Icon for Solution Sage rankSolution Sage
9 years ago
Solved

Stuck with Multiple If Conditions

I have this below table. I am trying to make custom column with the below criteria. But, I am not sure how to use PBI IF condition. (in excel it is pretty easy).   if [No of Days] > 50 and < 150, "...
Need Help
  • Eric_Zhang's avatar
    Eric_Zhang
    9 years ago

    rocky09

     

    Try to use SWITCH

    Column =
SWITCH (
    TRUE (),
    yourTable[No Of Days] > 600, "Critial",
    yourTable[No Of Days] > 150, "Just Below Critica",
    yourTable[No Of Days] > 50, "Under Control",
    "Normal"
)
Eric_Zhang's avatar
Eric_Zhang
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

rocky09

 

Try to use SWITCH

Column =
SWITCH (
    TRUE (),
    yourTable[No Of Days] > 600, "Critial",
    yourTable[No Of Days] > 150, "Just Below Critica",
    yourTable[No Of Days] > 50, "Under Control",
    "Normal"
)