Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Using conditional statement with regex

Hello,   I am using powerbi desktop to process my monthly bank transactions, and i am trying to categorise transactions.   I can do this with a conditional matching a single value, eg.   = Tabl...
Need Help
  • MarcelBeug's avatar
    MarcelBeug
    8 years ago

    You can use Splitter.SplitTextByAnyDelimiter to split texts on any delimiter with multiple characters (unlike Text.SplitAny).

     

    = Table.AddColumn(#"Lowercased Text", "Category", each if List.Count(Splitter.SplitTextByAnyDelimiter({"marini","zeebra","baker","mcdonalds"})([Description])) > 1 then "food" else null)
Rickmaurinus's avatar
Rickmaurinus
Icon for Helper V rankHelper V
5 years ago

Old topic, but the easiest solution you could do is use List.Contains, and then reverse the arguments. So first put in the list with the words you are looking for. And then as value, put in the [Description] column. Hope that helps 🙂 

 

 

= Table.AddColumn(ProperCaseFirst2Rows, "Category", each if List.Contains( { "marini" , "zeebra" , "baker" , "mcdonalds"} , [Description] ) then "food" else null)

 

 

--------------------------------------------------

@ me in replies or I'll lose your thread

 

Master Power Query M? -> https://powerquery.how

Read in-depth articles? -> BI Gorilla

Youtube Channel: BI Gorilla

 

If this post helps, then please consider accepting it as the solution to help other members find it more quickly.