Is there a way to use a filter/ slicer in a dashboard from one table to filter/ slice another table in the same dashboard?
For example, Table 1 has dates from 2018 to 2019. Table 2 has dates only in 2019. In my dashboard I am using a date filter/slicer from Table 1. Now I have Table 2 in the dashboard but when I use the filter/ slicer from Table 1, Table 2 charts do not slice correctly. The data is wrong.
I cannot create a lookup field between dates in tables.
Is there a SQL statement to create a Date Calendar to tie the dates together or another SQL statement to tie Table 1 and Table 2 together so that when a filter/ slicer is applied, it will pull the right data from Table 1 and Table 2?
Thank you