Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Wildcard in search function

Hi all,   I'm trying to figure out how to use the wildcard within my search code as I don't want to repeat the code over and over so if I have Oranges it will put it in the Oranges catagory but if ...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    Anonymous , I think it should be like

    SearchFeature = SWITCH (
    TRUE (),
    SEARCH ( "Oranges", 'Query1'[Column],, 0 ) > 0, "Oranges",
    "Others")

     

    Search return position

FrankAT's avatar
FrankAT
Community Champion
6 years ago

Hi Anonymous 

you can use wildcards '*' and '?' in SEARCH() function, but as amitchandak mentioned there is no need for your example.

Take a look at: https://docs.microsoft.com/en-us/dax/search-function-dax

 

With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)