Forum Discussion

Pawan's avatar
Pawan
Frequent Visitor
3 years ago
Solved

contains function

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

 

Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    Pawan , A new columns

     

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

     

    or

     

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

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    Pawan , A new columns

     

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

     

    or

     

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