I have a problem concerning two dates dimension from two different tables.
I've solve the problem when looking at months by doing below.
However, I also have to look into weeks and days. And doing that the same way as above would be to much work, and inefficient.
So how can i accomplish above solution in another more simpel way?