brand switch analysis

Question

Hi,&nbsp;I want to do a brand switch analysis,&nbsp;&nbsp;i have following table, where in 2020/6 the brand "ABC" did an advertising campaign for their product "water".&nbsp;I want to get 3 values:1) new customer (during campaign) -&gt; 1 (customer id no. 2)2) brand switch (during campaign) -&gt; 1 (customer id no. 1, switch from DEF to ABC)3) repeat (no change in purchase behaviour)&nbsp; -&gt; 1 (customer id no.3 , no change before and after the campaign bought ABC's water)&nbsp;year-monthcustomer idproduct (bought)brand nameadvertising flag2020/51waterDEF&nbsp;2020/53waterABC&nbsp;2020/62waterABCyes2020/61waterABCyes2020/63waterABCyes

amitchandak · Accepted Answer

Anonymous , for the new customer, you can column/measure rank of Month inside the customer , so rank one means new.
&nbsp;
For Rank Refer these linkshttps://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measureshttps://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columnshttps://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finalehttps://community.powerbi.com/t5/Community-Blog/Dynamic-TopN-made-easy-with-What-If-Parameter/ba-p/367415

Forum Discussion

brand switch analysis

2 Replies

Related content

Cohort analysis

Alternative to SWITCH ()?

Switch -Containsstring

Retention analysis

Calculate switching between brands

year-month	customer id	product (bought)	brand name	advertising flag
2020/5	1	water	DEF
2020/5	3	water	ABC
2020/6	2	water	ABC	yes
2020/6	1	water	ABC	yes
2020/6	3	water	ABC	yes