Forum Discussion
DAX SEARCH - Not working
Hello Guys
I have a formula in excel: =IF((ISNUMBER(SEARCH("[email protected]",[@[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
Hi Anonymous,
Please try this formula:
Column = IF(ISERROR(SEARCH("[email protected]",[@[To Field]]],0)),"Yes","No")Best regards,
Yuliana Gu
1 Reply
Hi Anonymous,
Please try this formula:
Column = IF(ISERROR(SEARCH("[email protected]",[@[To Field]]],0)),"Yes","No")Best regards,
Yuliana Gu