Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Finding substring with multiple values

Similar problems have been answered before but the solutions are not quite working in my case. I'm relatively new to DAX, so not sure if this is easily solvable.   My main data source is quite larg...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

     

    Please use the following DAX formula to create a calculated column:

    Column =IF(
      SUMX(MatchList,
           FIND(
                UPPER(MatchList[Keyword]),
                UPPER(Companies[Company])
                ,,0
               )
          ) > 0,
      “YES!”,
      “Probably Not”
     )

     

    Best Regards,
    Eyelyn Qin
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

KNP's avatar
KNP
Icon for Super User rankSuper User
4 years ago

Do you have the complete list of words somewhere?

I'd be referencing that and using a PowerQuery formula to flag the rows.

That way you have a dynamic solution simple by adding new values to the list.

  • itsme's avatar
    itsme
    Icon for Resolver I rankResolver I
    4 years ago

    Yes! This would be the way to go for long term solution, especially if that list changes. All you'd need to do is update that list somewhere (e.g. Excel in SharePoint...), bring that list into PQ, and reference it in a PQ formula similar to the IN operator in DAX.