Requirement - users need to see the currency conversion rates for any date in the chart. The rates comes from the source where rates are maintained and it has the record when the rates changes.
we have existing master calender exists in the data model which contains full set of dates.
So May know the process to use to meet the requirement.
I have certain inputs where I have conversion table and master calender . I have attached this inputs in the excel file.
we like to proceed with the approach based on auto generate to create the new calendar from the min and maximum dates of the currency conversion table and concatenate with the master calendar.
