Forum Discussion

PlastiquesMoore's avatar
PlastiquesMoore
Regular Visitor
6 years ago
Solved

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!
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    6 years ago

    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")

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

     

    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

PlastiquesMoore's avatar
PlastiquesMoore
Regular Visitor
6 years ago

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.

v-juanli-msft's avatar
v-juanli-msft
Community Support
6 years ago

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")

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

 

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