Forum Discussion

EZimmet's avatar
EZimmet
Icon for Resolver I rankResolver I
3 years ago
Solved

Use Excel input for Text Contains function within PBIX

Good Day and Thank you    I'm looking to see how to perform the below sorry I can't provide more info as I've never attempted this prior not really sure how to phrase it. Currently have a SQL DB ...
Need Help
  • MFelix's avatar
    MFelix
    3 years ago

    Hi EZimmet ,

     

    Add a new colum with the following code:

    if
  List.AnyTrue(
    List.Transform(
      Table1_Sharepoint[Path],
      (x) => Text.Contains([Path], x)
    )
  ) then "Text Exists" else null

     

     

     

EZimmet's avatar
EZimmet
Icon for Resolver I rankResolver I
3 years ago

Thank You Miguel

You were spot on with this solution ðŸ˜Ž