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 [Sev...
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi Anonymous 
    Please try

    Value =
IF (
    'Table'[Severity#] = 37,
    IF ( 'Table'[High Potential?] = "Yes", 3, 7 ),
    'Table'[Severity#]
)
tamerj1's avatar
tamerj1
Community Champion
3 years ago

Hi Anonymous 
Please try

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

    Thank you so much for your help, much appreciated.