Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!
What am I doing wrong in this case?
Solved! Go to Solution.
The issue is because one of the columns type was ABC123, after it was changed to text the formula worked.
View solution in original post
if [x] = "yes" and if [y]="yes" then 1 else 0
It still doesn't work, even if I use 1 and 0
Sorry my bad. gave you wrong solution initially. Apologies.
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
