While I was writing my part (PowerPivot) of an article about Microsoft Office 2010 for the German computer magazine “c’t” (issue 16/2010), I noticed that the DAX function “Search” apparently supports wildcards. However I did not find any explanations for the use of wildcards in this function on the online help website for PowerPivot.
The PowerPivot specialist Kaspar de Jonge not only writes very interesting articles about PowerPivot in his blog, but also provides an online form, where anyone who wants can ask questions about PowerPivot. So, I asked him, if he could help and if he can confirm that wildcards are allowed in the DAX function. Kaspar put me on the right track: most PowerPivot functions are not only similar to the Excel functions but in many cases the code from these functions has been copied and pasted from Excel to PowerPivot. So, as the Excel “Search” function allows the use of wildcards, the corresponding PowerPivot function will also allow wildcards. At this point, thanks again to Kaspar.
The online help for the Excel “Search” functions states that characters “?” and “*” can be used as wildcards in the “find_text” argument of the function.