Skip to main content

    Power BI

    Needs Votes

    Wildcard in Q&A

    Vote (8) 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

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