cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JamesA Frequent Visitor
Frequent 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.

 

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_OutcomeOverscoreMatch column
SatisfactorySatisfactory with minors 
2 REPLIES 2
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


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

JamesA Frequent Visitor
Frequent Visitor

Re: DAX help - IF statement

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

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors