Forum Discussion
Search Function in DAX (wrong data type or an invalid value error)
Hi thomas_raphael , if you are trying to add a new column, you could consider using Power Query to perform this function. It may be easier to see the results.
Please note that SEARCH("RunID",Incidentes[Description3],,BLANK()) will return a number representing the starting position of the text. "Find Text Value" - if I use search to find "Text" the result will be 6. If the search fails, the result is BLANK(). You may need to change the BLANK() to either 1 or 1000.
This result could be passed to the second VAR function. But it will only find position of the first "," after this start positon. 1, 6 or 1000. It there is no "," is returns BLANK().
Hi thomas_raphael , if you are trying to add a new column, you could consider using Power Query to perform this function. It may be easier to see the results.
Please note that SEARCH("RunID",Incidentes[Description3],,BLANK()) will return a number representing the starting position of the text. "Find Text Value" - if I use search to find "Text" the result will be 6. If the search fails, the result is BLANK(). You may need to change the BLANK() to either 1 or 1000.
This result could be passed to the second VAR function. But it will only find position of the first "," after this start positon. 1, 6 or 1000. It there is no "," is returns BLANK().
Hey Anonymous,
I can't use Power Query 'cause I'm creating this table from a published dataset, buuut your tip about changing the BLANK() to 1 made it finally work!
Thank you for that!
