Skip to main content

    Power BI

    New

    Wildcard in Q&A

    Vote (7) Share
    Grant Hensel's profile image

    Grant Hensel on 19 Feb 2016 03:52:22

    As a user, I want to reference columns that I can't remember the exact name for. Having a wildcard character (such as % or *) would prevent me from getting stumped because I typed the wrong version of a column name

    Comments (1)
    Grant Hensel's profile image Profile Picture

    d41fd652 3cc7-ea11-a812-000d3a9b112e on 15 Aug 2020 08:46:04

    RE: Wildcard in Q&A

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