Forum Discussion
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.
At same time i will calculate copies and (plafond year by year i can spend)
Can someome give me some lights about this topic?
Thank you in advance
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.
3 Replies
_AAndradeResident Rockstar
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.- ray_aramburo
Super User
You can copy this DAX code fiscal year template from this page and adjust it to your needs: https://goodly.co.in/financial-year-calculation-excel-and-power-bi/
Syndicate_AdminAdministrator
- 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.
