title: Using one slicer (Date) with two different tables and two different data columns
body: <p>I have several tables in my data model.</p>
  <p>Among others I have the table</p>
  <ul>
  <li>&quot;Sales&quot; (with all sold products by customer, date and marketing source) and the table</li>
  <li>&quot;Media Spend&quot; (with all marketing sources and their budget per month).</li>
  </ul>
  <p><strong>TABLE &quot;SALES“</strong></p>
  <p><strong>Product | Contract ID | Customer ID | Sales Date                      | Source</strong></p>
  <p>A             | 001               | C1                    | dd.mm.yyyy hh.mm.ss | Source A</p>
  <p>B             | 002              | C2                    | dd.mm.yyyy hh.mm.ss | Source B</p>
  <p>B             | 003              | C1                    | dd.mm.yyyy hh.mm.ss | Source B</p>
  <p>C            | 004              | C3                    | dd.mm.yyyy hh.mm.ss | Source C</p>
  <p>D            | 005              | C6                    | dd.mm.yyyy hh.mm.ss | Source F</p>
  <p><strong>TABLE „MEDIA SPEND“</strong></p>
  <p><strong>Source     | Spend | Campaign Month</strong></p>
  <p>Source A   | 500 € | mm.yyyy</p>
  <p>Source B   | 600 € | mm.yyyy</p>
  <p>Source C   | 300 € | mm.yyyy</p>
  <p>Source D   | 100 € | mm.yyyy</p>
  <p>Source E   | 550 € | mm.yyyy</p>
  <p>Source F   | 1,000 € | mm.yyyy        |</p>
  <p>The tables are connected by the relation &quot;Source&quot;.</p>
  <p>It should be mentioned that the &quot;Sales Date&quot; is much more detailed (dd.mm.yyyy hh.mm.ss) than the &quot;Campaign month&quot;) (mm.yyyy).</p>
  <p>This allows me to filter both customers and marketing budgets by &quot;Source&quot;.
  But at the same time I want to calculate / filter by Date (e.g. „Sales date“).
  But this is not possible.</p>
  <p><strong>How can I proceed to relate the two different columns in different tables?</strong></p>
  <p>I have already tried the following</p>
  <p>Build the Relation based on both Date-Columns
  =&gt; Problem shift from Date to Source</p>
  <p>Second connection (besides &quot;Source&quot;) created for the columns &quot;Sales Date&quot; and &quot;Campaign&quot; month.
  =&gt; The data model shows the connection as dashed. Otherwise there is no effect.</p>
  <p>THANX!</p>