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)

     
YGoe's avatar
YGoe
New Member
9 years ago

 Hi sokg,

 

I tried what you proposed and the error remains.

there is an error that is linked to the column 'home accounts'[acc_name] as it has a red line underneath it. 

 

I honestly do not know why. You may find below a snapshot of the table accounts

 

sokg's avatar
sokg
Solution Supplier
9 years ago

Could you give a print screen from the error you get with my formula

 

  • YGoe's avatar
    YGoe
    New Member
    9 years ago

    sokg there you go. 

     

    • 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,