Stuck with Multiple If Conditions

[rocky09]

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, "Under Control", if [No Of Days] >150 and < 600, "Just Below Critical", if [No of Days] > 600, "Critical", " Normal"

Table here:

 PartNo      Category            Order Date                                                                 No Of Days

6884	Technology	Friday, November 11, 2016	121
6884	Office Supplies	Thursday, October 01, 2015	528
6916	Furniture	Saturday, October 01, 2016	162
6980	Office Supplies	Wednesday, July 09, 2014	977
6982	Office Supplies	Tuesday, August 27, 2013	1293
6982	Office Supplies	Tuesday, August 27, 2013	1293
6982	Office Supplies	Monday, June 16, 2014	1000
7110	Office Supplies	Monday, June 16, 2014	1000
7430	Office Supplies	Sunday, March 23, 2014	1085
7906	Office Supplies	Monday, February 25, 2013	1476
8391	Technology	Friday, November 22, 2013	1206
8419	Office Supplies	Friday, November 22, 2013	1206
8419	Furniture	Monday, June 08, 2015	643
8833	Office Supplies	Monday, June 08, 2015	643
8995	Furniture	Tuesday, August 04, 2015	586
8995	Furniture	Thursday, May 29, 2014	1018
8995	Technology	Saturday, November 24, 2012	1569
8995	Technology	Friday, February 13, 2015	758
8995	Office Supplies	Friday, February 13, 2015	758
9126	Office Supplies	Wednesday, April 15, 2015	697
9127	Office Supplies	Wednesday, April 15, 2015	697
9509	Technology	Monday, March 11, 2013	1462
9509	Office Supplies	Monday, March 11, 2013	1462
9509	Office Supplies	Saturday, March 08, 2014	1100
9763	Technology	Saturday, March 08, 2014	1100
9927	Office Supplies	Tuesday, August 04, 2015	586
9927	Office Supplies	Monday, May 05, 2014	1042
9927	Technology	Sunday, December 22, 2013	1176
10022	Office Supplies	Thursday, November 07, 2013	1221
10437	Office Supplies	Wednesday, October 21, 2015	508
10499	Technology	Tuesday, December 31, 2013	1167
10535	Technology	Tuesday, December 31, 2013	1167
10535	Furniture	Thursday, October 09, 2014	885
10789	Office Supplies	Thursday, October 09, 2014	885
10791	Furniture	Sunday, September 22, 2013	1267
10945	Office Supplies	Friday, July 18, 2014	968

Thank you in advance,

[Eric_Zhang · Accepted solution]

@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"
)

[rocky09]

Thank you @Eric_Zhang