Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Using Power M to return a value based upon a partial match

I have looked but I don't think this is possible, but hopefully I'm wrong. BTW, I'm making things up here, so ignore any logical issues 🙂     Ticket ID Long Description 1237 Active Direct...
Need Help
  • camargos88's avatar
    camargos88
    5 years ago

    Anonymous ,

     

    Try this code for a custom column:

    let _text = [Long Description] in
Table.SelectRows(Search, each Text.Contains(_text, 
[Search For]))

     

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thanks for this.

Using the example code it works perfectly fine.