Forum Discussion
Segmenting customer by purchase behavior
Hello,
I am hoping someone could help.
I want to segment my customer by : buyer who bought once, every 2 month, every 3 month, etc..
For that i have a table with unique ID and date of their first order, i have another table with all the purchase history for a year with the same ID, Transaction ID, date of the order and the product they bought.
I tried to use a custom column in the first table but i have a hard time to be able to use a DAX formula that can join my two tables...
If someone has a better idea, that would save my day !!
Thank you in advance
Best regards
hi, Anonymous
Assuming that if Customer A buy something on 1,3,4,6,10 month, what group should be for him? every 2 month, every 3 month, every 4 month?
So sample data and expected output would help tremendously.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Best Regards,
Lin
5 Replies
v-lili6-msftCommunity Support
hi, Anonymous
What is the logic of "every 2 month, every 3 month, etc.." ?
If one customer is every 2 month and every 3 month, which group should be segmented into.
Sample data and expected output would help tremendously. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Best Regards,
Lin
Hello,
Sorry for my late answer.
My purpose is to group customer based on their purchase behavior Like
Customer A,B,C buy every 2 month
Customer D,E,F buy every 3 month
Customer G,H,I buy every 4 month
Customer J,K,L bought only once etc...
That i can use to understand my customer retention.
Is it more clear ?
Thank you in advance
Best regards
- v-lili6-msft
hi, Anonymous
Assuming that if Customer A buy something on 1,3,4,6,10 month, what group should be for him? every 2 month, every 3 month, every 4 month?
So sample data and expected output would help tremendously.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Best Regards,
Lin