Conditions based on multiple values

[Anonymous]

Hi Team,

I have score column, I  have create a new column with the below condition 

If score is lesss than or equal to 4 then Low

If Score is 5 & 6 then medium

If score is 7 & 8 High 

Thanks in  Adavce !

[Anonymous · Accepted solution]

Hi @Anonymous ,

What's the data type of field Score? It is whole number or decimal number? And the highest value of score is 8? You can create a calculated column as below:

Column = 
IF (
    'Table'[Score] <= 4,
    "Low",
    IF ( [score] >= 5 && [Score] <= 6, "Medium", "High" )
)

Best Regards

[amitchandak]

@Anonymous , A new column

Switch(true(),

[score] <=4 ,"Low",

[score] <=6 ,"medium",

[score] <=8 ,"High"

)