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 (2)
RE: Search or Filter with a Wildcard
Our organization is using Power Bi to analyze scientific data. Here is one specific example that our scientists have complained about - finding material descriptions in filters that pertain to ions is currently difficult since ion exists in so many words that are not contextually relevant. This is one of many examples that would require more advanced use of wildcards to narrow the search down to specifically what the scientists are looking for.
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, ....