Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to Solution.
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
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.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingI did this and I'm getting an error message.
= if ([#"External PPM - Medical Planifié"] = [#"External PPM - Medical Actuel"] then "Match" else "No match")
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.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingHi,
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.
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
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
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingWell, 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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.