Forum Discussion

agkolkata's avatar
agkolkata
Regular Visitor
3 years ago
Solved

search column A and column B for specific string existence in its text, and update column C based on

help needed in how to:

 need to use DAX to search column A and column B for specific string existence in its text, and update column C based on that

Need Help
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    3 years ago

    Hi, agkolkata ;

    You could try to create a column by dax.

    Column = 
IF(
CONTAINSSTRING([Column1],"ZZ")&&CONTAINSSTRING([Column2],"B_C"),666,[Column3])

    The final show:


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 Replies

  • Uspace87's avatar
    Uspace87
    Icon for Resolver III rankResolver III
    3 years ago

    agkolkata 

     

    You cannot modify the content of a column with DAX, the only way is to create custom column in "Power Query Editor" or Create a new Column after you load the data.

     

    Please find belowe an example in power query editor:

     

     

  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    Icon for Community Support rankCommunity Support
    3 years ago

    Hi, agkolkata ;

    You could try to create a column by dax.

    Column = 
IF(
CONTAINSSTRING([Column1],"ZZ")&&CONTAINSSTRING([Column2],"B_C"),666,[Column3])

    The final show:


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.