Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello Guys
I have a formula in excel: =IF((ISNUMBER(SEARCH("alerts@xpto.com",[@[To Field]]))),"Yes","No")
I am trying to perform an if test on a column that contains strings in PowerBI, but i m not able to do it.
Can you guys help pls?
Thanks
Solved! Go to Solution.
Hi @Anonymous,
Please try this formula:
Column = IF(ISERROR(SEARCH("alerts@xpto.com",[@[To Field]]],0)),"Yes","No")
Best regards,
Yuliana Gu
Hi @Anonymous,
Please try this formula:
Column = IF(ISERROR(SEARCH("alerts@xpto.com",[@[To Field]]],0)),"Yes","No")
Best regards,
Yuliana Gu