Master Calendar

[Pomna]

Experts,

I have a master calendar that works fine but am having issues getting 'YearQuarter'.  Any suggestions how to achieve that would be appreciated. Thank you

[tresB]

Could you explain with an example?

[Pomna]

The below is a sample calendar (Not Mine). It has year, quarter, month , day and week. I need the calendar to show YearQuarter.  For example

2021 Q1

2021 Q2

CalendarMaster:

LOAD

    Date(InvoiceDate) AS InvoiceDate,

    Year(InvoiceDate) AS Year,

    'Q' & Ceil(Month(InvoiceDate) / 3) AS Quarter,    

    Month(InvoiceDate) As Month,

    Day(InvoiceDate) As Day,

    Week(InvoiceDate) As Week;

Load Date(MinDate + IterNo() -1 ) AS InvoiceDate While (MinDate + IterNo() - 1) <= Num(MaxDate);

Load

    Min(InvoiceDate) AS MinDate,

    Max(InvoiceDate) AS MaxDate

RESIDENT Invoice;

[tresB]

Is it not just concatenation?  Like:

Year & ' ' & Quarter   AS   YearQuarter