Power BI

发布于 2020-04-07 10:21:58

I'll describe my question using an oversimplified, hypothetical example.

Let's say I have a text column with a bunch of random words in it. I want to make a new True/False column based on whether or not a word in that row contains the letter A. I can use the following DAX formula:

ContainsA = IF((SEARCH("A",Table[Words],,0))>=1,TRUE(),FALSE())

So, if you're here looking for a solution to this problem, this does work. My question is this:

Is there a better way to do this? Surely there must be some DAX function that returns True/False directly, right?

Questioner

yaxx0r

Viewed

82

Chinese

Original

Alexis Olson 2020-02-01 02:25

Try the CONTAINSSTRING function.

ContainsA = CONTAINSSTRING ( Table[Words], "A" )

Related issues

1

Reverse regex pattern match

2

egrep regular expression + print specific names from files with egrep

3

Find multiple occurences of same string

4

How can I get a list of the words that have six or more consonants in a row using the grep command?

5

matching python multiline expression string from a file using grep?

6

How to remove IP(s) from a text file based on given CIDR?

7

GREP Regex not working properly, but my regex is correct

8

extract and print all occurrences of disk file (.img) from a configuration file

9

Bash grep doesn't return the first regex match

10

Find youtube url in json file with ruby