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 an...
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 ,

     

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 ,