PowerBi : String grouping including variants

[Anonymous]

Hello,

I have a column field called  source/medium  for which has  different channels. However, I am stuggling to create a group for (FB organic and facebook/paid  FB Paid .

For instance I want to make sure that any source/medium field  that contains facebook or Facebook or FB, and paid or Paid is grouped as FB Paid and any source/medium field  containg facebook or Facebook or FB and organic or Organic is grouped as FB Organic and else as others.

Someone can help me in this?

Thank you in advance

[amitchandak · Accepted solution]

@Anonymous , Try a new column like

if ( (search("Facebook",[source/medium],,0) >0 || search("FB",[source/medium],,0) >0 ) ,
SWitch( true() ,
search("paid",[source/medium],,0) >0 ,"FB Paid",
search("organic",[source/medium],,0) >0 ,"FB Organic ",
"Others"
), "Others")