Forum Discussion
Result based on the values
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 |
Anonymous , A new column
Switch(true() ,
[Risk] <= 4, "Low" ,
[Risk] <= 6, "Medium" ,
"High"
)
Hi Anonymous
here is the formula
Risk Type =VAR _Risk =SELECTEDVALUE ( Sheet1[Risk Score] )RETURNIF ( _Risk <= 4, "Low", IF ( _Risk <= 6, "Medium", "High" ) )
2 Replies
Anonymous , A new column
Switch(true() ,
[Risk] <= 4, "Low" ,
[Risk] <= 6, "Medium" ,
"High"
)
Hi Anonymous
here is the formula
Risk Type =VAR _Risk =SELECTEDVALUE ( Sheet1[Risk Score] )RETURNIF ( _Risk <= 4, "Low", IF ( _Risk <= 6, "Medium", "High" ) )