Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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)), ", ")
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
39 | |
21 | |
20 | |
13 | |
13 |