Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

PowerBi : String grouping including variants

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

Need Help
Show and Tell
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    5 years ago

    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")

1 Reply

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    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")