Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

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.



Sat > sat

Sat> sat minor

Sat minor > Sat

Risk of > risk of

Unsat > unsat



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_OutcomeOverscoreMatch column
SatisfactorySatisfactory with minors 
Super User IV
Super User IV

Re: DAX help - IF statement

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


Not the Power BI thought police...

I have NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Regular Visitor

Re: DAX help - IF statement

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

Helpful resources

New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors