Forum Discussion
DAX help - IF statement
Hello I am wanting to add a conditional column in my dataset so it checks for the following outcomes. The column would then be a Match or Non Match. So something like IF(AND(??
See below outcomes.
MATCH
Sat > sat
Sat> sat minor
Sat minor > Sat
Risk of > risk of
Unsat > unsat
NO MATCH
Sat> risk of/unsat
Sat minor > risk of/unsat
Risk of > sat/sat minor/ unsat
Unsat> sat/sat minor/ risk of
My data looks a bit like this - Mock up
| Customer_Outcome | Overscore | Match column |
| Satisfactory | Satisfactory with minors |
2 Replies
You could do it that way but using && and || is cleaner in my opinion. And you might consider SWITCH
