Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Returning value based on multiple criteria

Please could you kindly help, I am trying to get a column to return a number based on: 

 

IF

[High Potential?] = No and blank 

[Severity#] = 37

Return 7

AND

[High Potential?] = Yes

[Severity#] = 37

Return 3

AND

[Severity#] = any other numbers

Return [Severity#] value

 

Thank you very much

  • Hi Anonymous 
    Please try

    Value =
    IF (
        'Table'[Severity#] = 37,
        IF ( 'Table'[High Potential?] = "Yes", 3, 7 ),
        'Table'[Severity#]
    )

2 Replies

  • tamerj1's avatar
    tamerj1
    Community Champion

    Hi Anonymous 
    Please try

    Value =
    IF (
        'Table'[Severity#] = 37,
        IF ( 'Table'[High Potential?] = "Yes", 3, 7 ),
        'Table'[Severity#]
    )
    • Anonymous's avatar
      Anonymous
      Not applicable

      Thank you so much for your help, much appreciated.