cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MaheshGupta Frequent Visitor
Frequent Visitor

IF condition

Hi,

 

I'm trying use an "if condition" to get an outcome. Here's the formula I'm using:

 

Column = IF(OR('All Incidents'[Ticket Type]="Closed", OR('All Incidents'[Ticket Type]="Resolved", 'All Incidents'[Ticket Type]="Resolved - Self Heal")), "Resolved","Active")

 

I need to get "Resolved", if any of the three types match the column else I should be getting "Active". When I input this formula, I was getting the outcome as "Active". Any help on this would be appreciated.

 

Regards,

Mahesh

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User
Super User

Re: IF condition

@MaheshGupta  Please try this as a new column 

 

Column = IF('All Incidents'[Ticket Type] IN {"Closed","Resolved","Resolved - Self Heal"},"Resolved","Active")


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

Proud to be a Datanaut !





5 REPLIES 5
Highlighted
Super User
Super User

Re: IF condition

@MaheshGupta  Please try this as a new column 

 

Column = IF('All Incidents'[Ticket Type] IN {"Closed","Resolved","Resolved - Self Heal"},"Resolved","Active")


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

Proud to be a Datanaut !





MaheshGupta Frequent Visitor
Frequent Visitor

Re: IF condition

@PattemManohar Thanks for the prompt response. However, I'm still getting the same outcome as "Active" in the results. Is there any other way to put this?

Super User
Super User

Re: IF condition

@MaheshGupta Please try checking the distinct values of that field by using table visual. Not sure, you have blanks as well in the data...


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

Proud to be a Datanaut !





MaheshGupta Frequent Visitor
Frequent Visitor

Re: IF condition

@PattemManohar There're no blanks in the column that I'm trying to map.

MaheshGupta Frequent Visitor
Frequent Visitor

Re: IF condition

@PattemManohar It's working now. Thank you, Manohar!!!

Helpful resources

Announcements
Community Highlights

Community Highlights

Find out what's new in the Power BI Community!

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 176 members 1,959 guests
Please welcome our newest community members: