Module 04 · Master data & calendar

Build a Calendar table with M code

Paste a short piece of M code into the Advanced Editor and get 365 dates complete with month, quarter and day.

Step by step8 minLesson 16 of 37 Members

The Tanggal column alone is not enough: the dashboard needs figures by month and by quarter, in January-to-December order, for Expense and Budget alike. A Calendar table (named Kalender in this course) provides exactly that: one row for every date in 2025, complete with year, month number, month name, quarter and day name. You don’t type 365 rows; you paste the M code below and Power Query builds the table for you.

Members only

Continue this course with a membership

Modules 1–2 of the Excel course are free. This lesson and 27 more are open to active members.

  • 5 steps with a numbered picture
  • All 37 Excel lessons, plus the Power BI, Tableau & Data Viz courses
  • A new Excel & dashboard template every day, with resell rights
  • Take paid client projects on the Project Board

One payment for 12 months, no automatic renewal. Back to the free lessons