Identify the total unique customers ordered again after a promotion

[Andrew_na_lang]

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! 

[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.

[danextian]

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_lang]

@danextian 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

Spoiler

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.