La generación de una tabla de fechas se realiza mediante creación de la «nueva tabla» en el apartado de «modelado»

Una vez creada la tabla se interta el siguiente código:

Date = 
ADDCOLUMNS (
	CALENDAR (DATE(2017;1;1); DATE(2025;12;31));
	"DateAsInteger"; FORMAT ( [Date]; "YYYYMMDD" );
	"Year"; YEAR ( [Date] );
	"Monthnumber"; FORMAT ( [Date]; "MM" );
	"YearMonthnumber"; FORMAT ( [Date]; "YYYY/MM" );
	"YearMonthShort"; FORMAT ( [Date]; "YYYY/mmm" );
	"MonthNameShort"; FORMAT ( [Date]; "mmm" );
	"MonthNameLong"; FORMAT ( [Date]; "mmmm" );
	"DayOfWeekNumber"; WEEKDAY ( [Date] );
	"DayOfWeek"; FORMAT ( [Date]; "dddd" );
	"DayOfWeekShort"; FORMAT ( [Date]; "ddd" );
	"Quarter"; "Q" & FORMAT ( [Date]; "Q" );
	"YearQuarter"; FORMAT ( [Date]; "YYYY" ) & "/Q" & FORMAT ( [Date]; "Q" )
)