cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
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
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
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 76 members 1,207 guests
Please welcome our newest community members: