Forum Discussion
Search exact text
Hi All,
I was trying to search for a string within the cell. In excel, i was able to get an exact keyword output. Can i get the same in Power BI. In below two conditions, word 'week' is appearing, however i wanted to see them as two different values.
=IFERROR(IF(SEARCH("babyweek6_f",$N2)>0,1,0),"")
=IFERROR(IF(SEARCH("week",$N2)>0,1,0),"")
I tried same with DAX, but, it is returning only word 'week' from the cell.
Can anyone help on this.
1 Reply
Can you supply some sample data. SEARCH function should be able to find those strings if they exist in the text.
https://msdn.microsoft.com/en-us/library/ee634235.aspx
SEARCH is case insensitive and accent sensitive. SEARCH also supports wildcard characters ? and *.
There is also FIND
https://msdn.microsoft.com/en-us/library/ee634882.aspx
FIND is case sensitive and does not support wildcard characters.
