Creating Date table school year

[mvanwill]

Hello,

I would like to make a date table wher I have a column to select the school year. The output should be "13/14". I can create begin year and the eind year. Here is the example:

Date =

ADDCOLUMNS (

CALENDAR (DATE(2014;1;1); DATE(2025;12;31));

"DateAsInteger"; FORMAT ( [Date]; "YYYYMMDD" );

"Jaar"; FORMAT ( [Date]; "YYYY" );

"Maand"; FORMAT ( [Date]; "MM" );

"Jaar-Maand"; FORMAT ( [Date]; "YYYY/MM" );

"Jaar-Maand kort"; FORMAT ( [Date]; "YYYY/mmm" );

"Maand-kort"; FORMAT ( [Date]; "mmm" );

"Maand-Lang"; FORMAT ( [Date]; "mmmm" );

"Dagnummer"; WEEKDAY ( [Date] );

"Weekdag"; FORMAT ( [Date]; "dddd" );

"Weekdag-kort"; FORMAT ( [Date]; "ddd" );

"Kwartaal"; "Q" & FORMAT ( [Date]; "Q" );

"Jaar kwartaal"; FORMAT ( [Date]; "YYYY" ) & "-Q" & FORMAT ( [Date]; "Q" );

"Schooljaar Begin"; if(month([Date])<8;YEAR([date])-1 ;YEAR([Date]));

"Schooljaar Eind"; if(month([Date])<8;YEAR([date]) ;YEAR([Date])+1)

)

I would like to combine the output to for example "13/14". The year starts in August and ends in July the next year.

What is the best solution?

[parry2k · Accepted solution]

@mvanwill it is like creating a fiscal calendar. and there are many posts on it. Here is link to one