Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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")
@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")
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
117 | |
105 | |
69 | |
67 | |
43 |
User | Count |
---|---|
148 | |
103 | |
103 | |
88 | |
66 |