Forum Discussion
Solved
Scholar Calendar
Hi, i would like to add a calendar in my powerbi related with scholar printing, like the year starts in september and finish at august, and the problem its related with scholar year and not civil one...
Hi,
Watch this video: https://www.youtube.com/watch?v=H8F60sgQZOI
Melissa de Korte has made a great M script that will help you with your school calendar. You can find the link in the video notes above.
Syndicate_Admin
Administrator
Administrator- Create a date table: Includes dates from September to August and adds columns for "School Year", "Quarter", "Month" (optional: "Week").
- Create measures: Calculate hard copies, total expenditure and remaining annual budget.
- Display: Design a chart with the school calendar , hard copies and expense. Add a line chart for the remaining annual budget.
- Filters: Analyzes data by school year, quarter or month.
In this way, your Power BI report will reflect the school year and calculate printing needs effectively.