I have three type of data:-
1) Actual Data with Start and End Date(TImestamp)
2) Planned Data with Start Date (Timestamp)
3) Forecast Data with Start Date(Timestamp)
I loaded 6 years to till date Calendar and renamed the Start Date in every type of data so that there is association between all the tables but synthetic key is coming.
Also when I am applying LEFT KEEP , it is only showing today;s date.
I am attaching QVF file as well as data.