Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Conditions based on multiple values

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 !

 

Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    Anonymous , A new column

     

    Switch(true(),

    [score] <=4 ,"Low",

    [score] <=6 ,"medium",

    [score] <=8 ,"High"

    )

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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