contains function

[Pawan]

Hi ,

I have a field like below. I need dax help to write

if Name contians Asian Fund LP,Asian Fund 4 then its yes else Name.

input:

Name:

ABC Asian Fund LP 90

Germany Asian Fund 4 as

argentina

expected output:

Name:

yes

yes

argentina

[amitchandak · Accepted solution]

@Pawan , A new columns

if( containsstring([Input], "Asian Fund"), "yes",[Input])

or

if( containsstring([Input], "Asian Fund") || containsstring([Input], "Asian Fund 4"), "yes",[Input])