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 ...
  • 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] ) )