I used below scripts to generate a date dimension table. however, the latest records is 3/24/2020 and I expected the table should store records up to 202003. But it now store up to 202012. How can I fix it?
DROP Table Temp;
MasterCalendar: Load *, AutoNumber(Period, 'PeriodID') as [PeriodID], AutoNumber(Year & Quarter, 'QuarterID') as [QuarterID] ; LOAD DISTINCT Year(Temp_Date) * 100 + Month(Temp_Date) as [Period], Year(Temp_Date) as [Year], Month(Temp_Date) as [Month], Date(Temp_Date, 'YYYY-MM') as [Year - Month], 'Q' & Ceil(Month(Temp_Date) / 3) as [Quarter] ; LOAD DISTINCT MonthStart($(vMinDate) + IterNo() - 1) as Temp_Date AUTOGENERATE (1) WHILE $(vMinDate) + IterNo() - 1 <= $(vMaxDate);