Hi ,
i have two tables that i need to use separate dates from but i only have the one DateKey in the MasterCalendar table. How do i handle this?
I.e.:-
Table A - contains contracts and the contract sign date
Table B - contains the contract returns and contract return date
i need to sum contracts signed and contracts returned.
I only have one %DateKey so I end up with several synthetic keys and the figures are not being picked up.
How can i handle this?
Laura
