Forum Discussion
Helper VIdentify the total unique customers ordered again after a promotion
Hi Fam,
I have a table where I identified the customers (Unique) who are considered as "Conversion".
Conversion is a customer who has used the first-time promotion in their first order.
I need to create another two calculated columns to know who amongst the converted customer's order for the second time and third time.
Thank you for your help!
4 Replies
- danextian
Super User
Hi Andrew_na_lang ,
Can you please post a sanitized copy of your pbix? It would be easier for me or anyone in the community to come up with a possible solution for your use case.
Andrew_na_langdanextian I don't know how to post the pbix file here. It says it is not supported
CUSTOMER ID PICKUP DATE ORDER ID First_ORDER_PROMOTION ORDER RANK TOTAL SALES A 2/12/2023 A12 Yes 1 25 B 2/12/2023 1df Yes 1 25 C 2/13/2023 gdxs Yes 1 63 D 2/13/2023 dsdr No 1 451 B 2/13/2023 eegs 2 14 A 2/14/2023 7gsdf 2 411 B 2/14/2023 dsgc 3 24 E 2/15/2023 wsrtsd Yes 1 3636 F 2/15/2023 sdfsdx Yes 1 45 G 2/15/2023 sdrcs Yes 1 5151 H 2/15/2023 sdsdsd 1 8452 E 2/17/2023 ppjvh 2 15162 I need to create another column for converted to second order
- For converted to second order, these are the customers who in are the customers with a tag of "Converted" in their first order. It is like I want to know how many customers who used the promotion in their first order still continues to order. I hope that makes sense- danextian
Hello,
You can a link to Google or One Drive or Dropbox.
- Andrew_na_lang
I need to create a calculated column so that I could also know eventually how many customers and how much is the total sales in their second order.
