Result based on the values

[Anonymous]

Hi Team,

I want to create a column as Score from the risk score

0 - 4 as Low 

5-6 as Medium

7-8 as High,

Here is my table

ID	Location	Project	Status	Risk Score
1001	IND	AA	Completed	0
1002	US	AB	In Progress	1
1003	IND	AC	Delayed	2
1004	UK	AD	Completed	3
1005	Global	AE	In Progress	4
1006	US	AF	Delayed	4
1007	Germany	AA	Completed	5
1008	IND	AF	In Progress	5
1009	US	AH	Delayed	6
1010	UK	BB	Completed	6
1011	Germany	AB	In Progress	7
1012	IND	AC	Delayed	7
1013	US	AF	Completed	8
1014	UK	AR	In Progress	8
1015	US	AG	Delayed	8

[amitchandak · Accepted solution]

@Anonymous , A new column 

Switch(true() ,

[Risk] <= 4, "Low" ,

[Risk] <= 6, "Medium" ,

"High"

)

[aj1973 · Accepted solution]

Hi @Anonymous 

here is the formula

Risk Type =

VAR _Risk =

SELECTEDVALUE ( Sheet1[Risk Score] )

RETURN

IF ( _Risk <= 4, "Low", IF ( _Risk <= 6, "Medium", "High" ) )

[amitchandak · Accepted solution]

@Anonymous , A new column 

Switch(true() ,

[Risk] <= 4, "Low" ,

[Risk] <= 6, "Medium" ,

"High"

)