Forum Discussion
IF formula
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
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.
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.
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