QuartersMap:  
MAPPING LOAD   
rowno() as Month,  
'Q' & Ceil (rowno()/3) as Quarter  
AUTOGENERATE (12);  
      

Temp:  
Load  
min([Start]) as minDate,  
max([End]) as maxDate  
Resident Capacity;  
// min(Month(Monthstart(Date([Start], 'DD.MM.YYYY')))) as minDate,  
// max(Month(MonthEnd(Date([End], 'DD.MM.YYYY')))) as maxDate  
// Resident Capacity; 


Let varMinDate = Num(Peek('minDate', 0, 'Temp'));  
Let varMaxDate = Num(Peek('maxDate', 0, 'Temp'));  
DROP Table Temp;  
      
TempCalendar:  
LOAD  
$(varMinDate) + Iterno()-1 As Num,  
Date($(varMinDate) + IterNo() - 1) as TempDate  
AutoGenerate 1 While $(varMinDate) + IterNo() -1 <= $(varMaxDate);  


MasterCalendar:  
Load  
  TempDate AS [Date],
  MonthName(TempDate) as MonthYear,
  num(0) as Value,
  week(TempDate) As Week,  
  Year(TempDate) As Year,  
  Month(TempDate) As Month, 
  MonthName(TempDate) as MonthName,
  Day(TempDate) As Day,  
  ApplyMap('QuartersMap', month(TempDate), Null()) as Quarter,
  Week(weekstart(TempDate)) & '-' & WeekYear(TempDate) as WeekYear,  
  WeekDay(TempDate) as WeekDay  
Resident TempCalendar  
Order By TempDate ASC;  
Drop Table TempCalendar;