Forum Discussion

YGoe's avatar
YGoe
New Member
9 years ago
Solved

Search text DAX not working

Dear All,    I am trying to perform an if test on a column that contains strings. After searching the web, I decided to use the search function.  I keep running in an error telling me that a singl...
Need Help
  • sokg's avatar
    sokg
    9 years ago

    Is home accounts{acc_name] already a calculated column?

     

    Try this one as a column

     

    test = IF(IFERROR(SEARCH("Transient Retail",'home accounts'[acc_name]),-1)=1,10,0)

     
sokg's avatar
sokg
Solution Supplier
9 years ago

At the end you have 2 parenthesis. You need only one.

YGoe's avatar
YGoe
New Member
9 years ago

I already tried removing brackets and moving the ,0 outside the first bracket. but it is still not working. 

 

I dont know why the selected column is not being recognised properly. 

 

is there another way to perform an if test on varchar datatype instead of numeric?

 

thanks,

  • sokg's avatar
    sokg
    Solution Supplier
    9 years ago

    Not brackets[ ] , i said parenthesis ( ) . You have two at the end.

    • YGoe's avatar
      YGoe
      New Member
      9 years ago

      sokg it is not solving the issue

       

      • sokg's avatar
        sokg
        Solution Supplier
        9 years ago

        Sorry my mistake, it was missing one parethesis after your column name

         

        try this

         

        test = IF(IFERROR(SEARCH("Transient Retail",'home accounts'[acc_name]),-1)=1,10,0)