Filtering Columns between two tables?

[Anonymous]

I have to separate tables for employees (The two example tables below are simply conceptual). One containing Billable Hours and the other containing Unbillable hours. They are related via "Employee Name"

The reason there is a column for "weeks passed since 1/1/2020" is because the Table 2 report only runs on a weekly basis. So the run date is the only date on that table and it ecapsulates everything in a 7 day period. I need to somehow relate Table 1 and Table 2 through the "Weeks Passed since 1/1/2020" so that when I have a visual showing billable and unbillable hours and I move my date slider it will grab the dates based on the "weeks passed since 1/1/2020" number.

I hope that makes sense. 

[AilleryO]

Hi,

I think that the best option would be to create a date table with a column (weeks passed since 1/1/20) and make a relationship from both tables with date table.

Then if you create a visual based on the dates from date table, it should work as required.

I don't know if it's possible in your case, but you have M function EndOfWeek StartOfWeek, that allows you to calculate the date ending or starting the week. So all your dates will be the same.

It might be another option and you will not need your weeks since 1/1/20 column.

Let us know what is best for you