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

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?

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    parry2k  Thank you so much!

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    parry2k - sorry for late response, just a follow up to better understand campaign sales in the mailers table.

     

    How exactly does this formula below work?

     

    It gives me the right answer, but having trouble following the logic.

     

    Campaing Sales = CALCULATE( COUNTROWS( Sales ), TREATAS( VALUES( Mailers[Campaign] ), Sales[Campaign] ) )
  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    parry2k  

     

    I did a bit more research, and It would be a ton of help if I could understand the logic below, but also I'm wondering why we didn't use a summarize along with customer id so we join on both customer id and mailers?

     

    It seems to be doing everything correctly, but I saw others using a summarize function.

     

    Campaing Sales = CALCULATE( COUNTROWS( Sales ), TREATAS( VALUES( Mailers[Campaign] ), Sales[Campaign] ) )