cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mvanwill Frequent Visitor
Frequent Visitor

Creating Date table school year

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?
 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Creating Date table school year

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

 

 






Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





View solution in original post

1 REPLY 1
Super User
Super User

Re: Creating Date table school year

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

 

 






Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





View solution in original post

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 270 members 2,981 guests
Please welcome our newest community members: