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 ...
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

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