Multiple Date Types With Multiple Table Keys

[madushanfernand]

Hi All

below shows the data tables i have used in my dash boards ( See Image No1 ). it has four date types to be considered. and i need one master calendar to link all four dates. i have already been through the posts on using Cannonical date. but my concern is, in this practical scenario i have no prime key to link all four tables.

keys are as follows.

1.      Key1 to Budget and Forecast Tables - Company, Buyer

2.      Key2  to Forecast and Confirmed Tables - Company, Buyer, ShopNo, RelNo, SeqNo

3.      Key3  to Confirmed and Actual Tables - Company, Buyer, OrderNo, LineNo, DelNo

what i need to get as the final out put is shown in the Image No 2. in yellow color i highlighted a data set linked as per the above keys.

and please find attached a sample data set herewith. could someone pls help to solve this matter. thanking in advance.

Image No 1.

Image No 2.

Thank you