I am trying to link the Dates with Master calendar through Link table concept as mentioned in the image attached but unable to get the desired results. Can anyone please help me in constructing the code for the same?
You need a link table, a canonical calendar or multiple calendars depending on your analytic requirements. Check the document by HIC for more details: Canonical Date
This may also help: How to use - Master-Calendar and Date-Values
Retrieving data ...