Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Olá,
Preciso agrupar de alguma forma algumas dimensões específicas da tabela abaixo. Tentei fazer com "Groupby", mas não consegui.
O grupo se chamaria "Mídia Paga" e seriam agrupados :
google / cpc
aquiles / abandoned
facebook / cpc_conv
aquiles / saleincomplete
voxusmediamanager / cpl
As outras dimensões seriam agrupados em "Outros". Não sei como poderia fazer, talvez um AllExcept com alguma outra função.
source medium | revenue |
google / cpc | R$ 75.000,00 |
voxusmediamanager / cpl | R$ 10.000,00 |
aquiles / abandoned | R$ 4.500,00 |
facebook / cpc_conv | R$ 6.000,00 |
facebook/ cpc_cv | R$ 2.000,00 |
google / organic | R$ 100.000,00 |
linktree / referral | R$ 2.000,00 |
Afilio / afiliado | R$ 1.000,00 |
bing / organic | R$ 500,00 |
aquiles / saleincomplete | R$ 1.000,00 |
l.facebook.com / referral | R$ 2.000,00 |
IGShopping / Social | R$ 500,00 |
Salesforce / Email | R$ 500,00 |
Direct / not set | R$ 10.000,00 |
Solved! Go to Solution.
Hi @mottamatheus835 ,
Depending on your requirements description, you want to implement the field "source medium" name grouped according to your own needs, right? If this is the case, you can try using this DAX expression to create a calculated column to achieve your needs:
Group name =
IF('Table'[source medium] in {"google / cpc", "aquiles / abandoned", "facebook / cpc_conv", "aquiles / saleincomplete", "voxusmediamanager / cpl"},"Mídia Paga","Outros")
Then the result is as follows.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @mottamatheus835 ,
Depending on your requirements description, you want to implement the field "source medium" name grouped according to your own needs, right? If this is the case, you can try using this DAX expression to create a calculated column to achieve your needs:
Group name =
IF('Table'[source medium] in {"google / cpc", "aquiles / abandoned", "facebook / cpc_conv", "aquiles / saleincomplete", "voxusmediamanager / cpl"},"Mídia Paga","Outros")
Then the result is as follows.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
41 | |
27 | |
23 | |
19 | |
16 |
User | Count |
---|---|
55 | |
35 | |
21 | |
18 | |
15 |