cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Marck
Helper I
Helper I

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

1 ACCEPTED SOLUTION
amitchandak
Super User IV
Super User IV

@Marck , 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")



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

1 REPLY 1
amitchandak
Super User IV
Super User IV

@Marck , 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")



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

March Update

Check it Out!

Click here to read more about the March 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.