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,
Based on the table below, can anyone help me write a custom column formula that will act as an IF function? Every time I try an IF statement, I am told that PowerBI does not recognize the IF term
Thank you in advance!
Solved! Go to Solution.
@JD ,
if function is power query is case sensitive. Your first one should work like this.
if ( [Search_Classification_C] = "Leadership Search"
and [Third_Bill_C] = "True" )
then 1
else 0
Think you should be able to follow the same syntax for your second bullet.
In future, please post data sample as text, not as a picture. Will help make it easier to solve your issues.
Hope this helps.
Regards,
@JD ,
if function is power query is case sensitive. Your first one should work like this.
if ( [Search_Classification_C] = "Leadership Search"
and [Third_Bill_C] = "True" )
then 1
else 0
Think you should be able to follow the same syntax for your second bullet.
In future, please post data sample as text, not as a picture. Will help make it easier to solve your issues.
Hope this helps.
Regards,
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.
User | Count |
---|---|
106 | |
105 | |
79 | |
69 | |
62 |
User | Count |
---|---|
142 | |
105 | |
103 | |
84 | |
70 |