DAX code for "greater than and less than" by way of if function

[navedkhan]

I want to write a dax function with "IF" condition basis following logic;

	Red	Amber	Green
T1	<= 20	>20 and <=50	> 50
T2	<=90	>90 and <=120	>120

So if Value falls in either of 3 categories (Red, Amber or Green); accordingly IF condition to calculate. my biggest problem occurs in 'Amber' column where a range of values need to be written in DAX.

Any help please?

@Zubair_Muhammad @Greg_Deckler 

[Anonymous]

@navedkhan 

You can try the below

1. IF(K11<=20,"red",IF(K11>50,"Green","Amber"))

2. IF(K11<=90,"red",IF(K11>120,"Green","Amber"))

Nandri

[Anonymous · Accepted solution]

I think this should do it.

=if(T1 <=20, "Red", if(T1 <=50, "Amber", "Green"))

=if(T2 <=90, "Red", if(T2 <=120, "Amber","Green"))