Skip to main content

    Power BI

    New

    Search or Filter with a Wildcard

    Vote (11) Share
    Vitalijs's profile image

    Vitalijs on 07 Dec 2017 05:11:47

    Search or Filter with a Wildcard like in Access, e.g. Text.Contains([Model], "AB*12*")

    Comments (1)
    Vitalijs's profile image Profile Picture

    d41fd652 3cc7-ea11-a812-000d3a9b112e on 15 Aug 2020 08:44:07

    RE: Search or Filter with a Wildcard

    I propose those wildcards:
    Sale !Sales for Sale but not Sales (! instead -)
    "Sale" for exact whole word Sale
    xxx* for starting with xxx
    *xxx for ending with xxx
    *xxx*yyy* for containing xxx and yyy (no matter in what order)
    x?y for xay, xby, x1y, x2y, .... but not xaby
    x#y for x1y, x2y, ....
    x&y for xay, xby, ....