Forum Discussion
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...
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)
it is a measure. I tried creating a calculated column but the operation that follows the if statement creates a circular reference.
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)