Calendarauto but include dates from previous fiscal years

[joeort]

I've used CALENDARAUTO(3) to create my calendar table but it starts at this fiscal year.  How would I compare YTD performance to the prior year if my calendar table doesn't contain those dates?

[LarsSchreiber · Accepted solution]

Hi @joeort,

CALENDARAUTO() automatically creates a table with one column named "date". The range of dates is calculated automatically based on data in the model. For having years included in your date-table, which are not part of your data model you cannot use CALCULATEAUTO(). Try something like the following:

YourCalendarTable =
CALENDAR (
DATE ( YEAR ( MIN ( YourTable[DateColumn] ) -1 ); 1; 1 );
DATE ( YEAR ( MAX ( YourTable[DateColumn] ) ); 12; 31 )
)

Regards,

Lars