The Date Table
Part of the Time Intelligence section of Coddy's Power BI journey. Lesson 1 of 17.
Dates has one row per day of 2024 and 2025, with Year, Quarter, Month, MonthNumber and Weekday.
It is linked to Sales[Date]. Slice by the Dates columns: time functions need the full calendar.
Month names sort A to Z; use MonthNumber on an axis.
Challenge
How did 2025 go, month by month? Build a line chart of Revenue with Dates[MonthNumber] on the axis, filtered to the year 2025.
All lessons in Time Intelligence
1Dates and Calendars
The Date TableCounting DaysWeekdays and WeekendsFirst and Last DatesRecap - Revenue per Day