Forum Discussion

murrayb8's avatar
murrayb8
Helper I
9 years ago
Solved

How to search for a string containing a question mark?

Hi Im using a search formula in Dax in the desktop tool and it seems that if I include a question mark in the string to search for the question mark is ignored and acts like a wildcard. I know with q...
  • Anonymous's avatar
    Anonymous
    9 years ago

    murrayb8,

    If you want to find an actual question mark, type a tilde (~) before the character. There is an example for your reference.


    In addition, I haven't found any list stating that how to escape special characters in SEARCH function. 

    Reference:
    https://msdn.microsoft.com/en-us/library/ee634235.aspx

    Regards,