However please help me clarify somethings, is your information in two different tables (Financial and Productivity) each one with their own date column, or are they in the same column and sharing the date column?
Can you also share some sample data and expected result.
Did I answer your question? Mark my post as a solution!
I created a table (visual, not backend) that shows the cost per unit which takes the amount from table two and divides it by units. As posted date and date worked are unique, I have to use two filters one to filter the units and another to filter the amount. My question is that since both dates have a linear relationship (if I know the date range for date worked, I can tell you the ddate range for posted date) is there a way to combine them into a single filter.
IE: If I select 1/1/2018 to 1/4/2018 for date worked, it will automatically filter the post-date to 1/5/2018 to 1/9/2018. Is that clearer?