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.