DAX question

[Kamchokshi]

Hi

i am new to Power BI. 
I need a DAX formula to check if fields contain a particular word. 

if text contains the word remote then return "yes" otherwise "no"

example

123Remotexyz. return "Yes"

123Physicalxyz. return "No"

[tackytechtom · Accepted solution]

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/

[Anonymous · Accepted solution]

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.}

[tackytechtom · Accepted solution]

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/