Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Creating a calculated column from another table based on date criteria

Example file with Sales and Mailers Tables Example End Product Conversion Chart by Campaign Background: We help boat dealers sell boats, we do marketing for them. I have 2 tables: Mailer table ...
parry2k's avatar
parry2k
Super User
7 years ago

Anonymous before i go deep into it, can you check if following campaign id i calculated for each dealdate looks correct based on the logic you provided.

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi parry2k  - sorry for late response - everything in your original table looks correct, except for 2 callouts.

 

  • Customer ID BM0001118195, the answer should be M1, not M5
  • Customer ID BM000190996 – should be M1 not M5
  • parry2k's avatar
    parry2k
    Super User
    7 years ago

    AnonymousI have solution ready, let me know where you want to send me. atleast this will get you started. Although on larger schema I will improve/make changes to data model.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Thank you so much parry2k - if you're not able to add it here (feel free if you prefer to add for anyone else to see), I have google drive or one-drive, not sure what works best for you to share?