I have 2 fact tables
- Labor hours by date
- Square Footage by date
If there are labor hrs but no sqft for the same date the labor hrs need to be added to the 1st date after that has sqft. Here is an example of the 2 fact tables and the desired results.
|date||labor hrs||date||Sqft||date||Sqft||labor hrs|