cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

IF formula

Hi everyone,

 

Hope everlone is doing well with this Covid-19 crap!

 

I have an Excel formula that I would like to use in Power BI.

 

=IF(A2=B2;"Match";"No Match")

 

Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: IF formula

Hi @PlastiquesMoore 

For the 'IF' column, if you create a measure or a calculated column, use formulas below:

Measure = IF(MAX([Column1])=MAX([Column2]),"match","no match")

Column = IF([Column1]=[Column2],"match","no match")

Capture6.JPG

if you open Edit queries, then add a custom column, you can do this way,

Capture7.JPG

 

As for the requirement,

"What I want to do is that when the value "0" has been found twice in the same row, I want a message to appear."

Please share a detailed example.

 

Best Regards

Maggie

sss

View solution in original post

7 REPLIES 7
Highlighted
Super User IX
Super User IX

Re: IF formula

Well, if it is a column, then you could use:

 

Column =IF([A Column]=[B Column];"Match";"No Match")

 

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a 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 Super User!




Highlighted
Super User VI
Super User VI

Re: IF formula

In Power Query, it would be in a custom column:

= if [Column A] = [Column B] then "Match" else "No Match"

Note PQ is case sensitive. 



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting
Highlighted
Regular Visitor

Re: IF formula

I did this and I'm getting an error message.

 

= if ([#"External PPM - Medical Planifié"] = [#"External PPM - Medical Actuel"] then "Match" else "No match")

 

 
 
Highlighted
Super User VI
Super User VI

Re: IF formula

Generally it should be columns. #"Someting here" refers either to an external query or a different step. If you are referring to a step, get rid of the brackets. Columns are [Columns] and steps are either Steps or #"A Step" if there is a space in it.

 

Unless you really know what you are doing, you should start out only using column references. [Column A] + [Column B] for example. Don't try to get advanced by referring to outside queries or other steps as your first if/then/else construct.



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting
Highlighted
Regular Visitor

Re: IF formula

Hi,

 

I'm still a beginner and learning! 🙂

 

I just tried this and it's still not working.

 

= if [External PPM - Medical Planifié] = [External PPM - Medical Actuel] then "Match" else "No match")

 

What I want to do is that when the value "0" has been found twice in the same row, I want a message to appear.

Highlighted
Super User VI
Super User VI

Re: IF formula

Please post sample data, or your PBIX file. I cannot tell if your syntax is wrong or if something else is going on because I don't know your column headings. See links below, then give me what your expected output is:

 

How to get good help fast. Help us help you.
How to Get Your Question Answered Quickly
How to provide sample data in the Power BI Forum



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting
Highlighted
Community Support
Community Support

Re: IF formula

Hi @PlastiquesMoore 

For the 'IF' column, if you create a measure or a calculated column, use formulas below:

Measure = IF(MAX([Column1])=MAX([Column2]),"match","no match")

Column = IF([Column1]=[Column2],"match","no match")

Capture6.JPG

if you open Edit queries, then add a custom column, you can do this way,

Capture7.JPG

 

As for the requirement,

"What I want to do is that when the value "0" has been found twice in the same row, I want a message to appear."

Please share a detailed example.

 

Best Regards

Maggie

sss

View solution in original post

Helpful resources

Announcements
Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Upcoming Events

Community Summit North America – Join Online!

Join this community-driven Power Platform digital event for unbiased support and problem-solving.

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Top Solution Authors
Top Kudoed Authors