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

Hi YGoe

 

Try this instead

 

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

 

Note this:   The search function is case insensitive

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