DAX help - IF statement

[Anonymous]

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

[Greg_Deckler]

You could do it that way but using && and || is cleaner in my opinion. And you might consider SWITCH

[Anonymous]

Can you give me an example of how I could use it Greg?