two tables, two different date fields ?

Anonymous — Thu, 08 Oct 2015 12:55:22 GMT

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

Re: two tables, two different date fields ?

Anonymous — Thu, 08 Oct 2015 12:57:24 GMT

Hi,

Please follow below post :