DAX question

Hi Kamchokshi ,

How about this:

LookupResult = 
IF ( ISERROR ( SEARCH ( "remote", 'Table'[Column] ) ), "No", "Yes" )

Let me know if this helped 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/

Hi Kamchokshi  ,

You can create a new column and input the following code:

Column =IF(CONTAINSSTRING('Table'[Column1],"remote"),"Yes","No")

Output:

^{Best Regards,}

^{Yolo Zhu}

^{If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.}