Forum Discussion

elakkiyaselvan's avatar
elakkiyaselvan
Frequent Visitor
3 years ago
Solved

Power bi wild card

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.

Need Help
  • bhelou's avatar
    bhelou
    3 years ago

    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 ,

     

1 Reply

  • bhelou's avatar
    bhelou
    Icon for Responsive Resident rankResponsive Resident
    3 years ago

    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 ,