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

amitchandak's avatar
amitchandak
Super 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")