Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
I'm trying to search a column, for a list of terms, and have any matches listed in the new column. For example, the column I want to search has a mash-up of text "AAAAAAABOBAAAAAAJOHNAAAAAAASUEAAAAA" and I want to find out which of my list of names are in the text. The list of names is {BOB, CHAD, SUE, MIKE, DON} and the result needs to be "BOB, SUE".
Solved! Go to Solution.
In a custom column, use following formula where [Text] is your column name and ListOfNames contains the names
Text.Combine(List.Select(ListOfNames, (x)=>Text.Contains([Text], x)), ", ")
In a custom column, use following formula where [Text] is your column name and ListOfNames contains the names
Text.Combine(List.Select(ListOfNames, (x)=>Text.Contains([Text], x)), ", ")
User | Count |
---|---|
19 | |
10 | |
10 | |
9 | |
7 |