Forum Discussion

Andrew_na_lang's avatar
Andrew_na_lang
Icon for Helper V rankHelper V
3 years ago

Identify 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.  ...
Tutorial Requests
danextian's avatar
danextian
Icon for Super User rankSuper User
3 years ago

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's avatar
Andrew_na_lang
Icon for Helper V rankHelper V
3 years ago

danextian I don't know how to post the pbix file here. It says it is not supported

CUSTOMER IDPICKUP DATEORDER IDFirst_ORDER_PROMOTIONORDER RANKTOTAL SALES
A2/12/2023A12Yes125
B2/12/20231dfYes125
C2/13/2023gdxsYes163
D2/13/2023dsdrNo1451
B2/13/2023eegs 214
A2/14/20237gsdf 2411
B2/14/2023dsgc 324
E2/15/2023wsrtsdYes13636
F2/15/2023sdfsdxYes145
G2/15/2023sdrcsYes15151
H2/15/2023sdsdsd 18452
E2/17/2023ppjvh 215162
       
        
        
        
        
        
        
        
        
        

 

 

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's avatar
    danextian
    Icon for Super User rankSuper User
    3 years ago

    Hello,

    You can a link to Google or One Drive or Dropbox.