The two calendars you have created is based on two different dates. We cannot consider those into one.
The important thing to decide is tha which date filter needs to be shown in UI for user to select. We can have a different date filters in two different tabs in UI according to the visualization.
Thanks for your reply, Karthikeyan.
Currently those 2 calendars are different, and I can link them up together. However, I still have one more fact table to connect. If I link them up together, I would have a loop. Therefore, in order to avoid, I wish to break up the date key into separate tables and perform lookup manually on charts.
For selection, I would like to have one calendar filter pane for users to select date range. Once the date range is selected, the selection will apply over the whole application.