Calculate data based on DB table & historical excel file

Calculate data based on live table & historical excel file.

Need to calculate total quotes:

1) For last 13 months data is available in DB

2) For period earlier than 13 month data is redacted from DB.

Can we somehow store the data fetched in Power Bi recursively?

If not then need to create a measure that will give total quotes from 2022 to till date:

DB will have data from Feb 2022 onwards but for Jan 22 it will be available in static excel file.

Table deatils:

1. DateTable is centralized table with all the calender date

2. DB is the data base table that hold current & last 13 month data

3. Historical table hold Jan 2022 data

Measure to be created that shows data for Jan 2022 from hostorical excel table and remaining month from DB and this will change as next month it should show Jan, Feb data from hostorical excel table and remaining from DB....

Total Quotes_test =

var mon_start_date =     CALCULATE(Min(DateTable[Date] ),ALLSELECTED(DateTable[Date] ))

var mon_end_date =     CALCULATE(Max( DateTable[Date] ),ALLSELECTED(DateTable[Date] ))

var yr = VALUE(SELECTEDVALUE(DateTable[Date]))

var curr_mon= MONTH(TODAY())

var curr_year= YEAR(TODAY())

return

if(DATE(curr_year-1,curr_mon,31)<=mon_start_date,CALCULATE(SUM('Historical Data Table'[Total Quotes]),'Historical Data Table'[Year]=curr_year-1 && 'Historical Data Table'[Month]=curr_mon),

CALCULATE(DISTINCTCOUNT('DB'[QCLIN]),'DB'[QDATE]>=mon_start_date && 'MSQUREFR New'[QDATE]<=mon_end_date) )