Forum Discussion

shaebert's avatar
shaebert
Icon for Helper III rankHelper III
2 years ago
Solved

3 Table Relationship Question

I feel like there is a simple answer to my question, but I can't figure it out.  I want to see the amount of Commission by Invoice Date with Date and Campaign slicers. I cannot create a relationsh...
Need Help
  • shaebert's avatar
    shaebert
    2 years ago

    The solution was to create a bridge table. See below:

     

Uzi2019's avatar
Uzi2019
Icon for Community Champion rankCommunity Champion
2 years ago

Hi shaebert 

 

Just simply follow this relationship. avoid creating relationship between Date > Campaign table 

 

 

I hope I answered your question!

 

 



shaebert's avatar
shaebert
Icon for Helper III rankHelper III
2 years ago

Thanks for taking a look, but this does not work (maybe I needed to provide further details). 

 

I want to create a Date slicer, that can filter the Campaigns (count) by the date they started, and/or by the Sum of Commission by the Date it was invoiced.

The solution you provided would not accuratly depict the number of campaigns that took during the time period, it would only depict the number of campaigns associated to Commission that was invoiced during that time period (invoice dates can take place up to a year after the campaign start date).