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 arg...
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])

amitchandak's avatar
amitchandak
Icon for Super User rankSuper 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])