Power bi wild card

[elakkiyaselvan]

Hi All,

I have a requirement to convert below Qlik script to Power bi 

// ID

if(WildMatch(Column,'*ABC*'),'N',
)

For example, I am trying to hot code a middle text that starts with any text and ends with any text using the wild card option in Power Bi Desktop.

[bhelou · Accepted solution]

hi check this measure if works with you : 

ID = IF(
        SEARCH("ABC", [Column], 1, 0) > 0,
        "N",
        BLANK()
    )

Please accept as a solution if it works with you . 
Regards ,