two tables, two different date fields ?

[Anonymous]

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

[Anonymous]

Hi,

Please follow below post :

Canonical Date