Power BI - Creating a M-agical Date Table
summary
A complete Power Query M calendar is built in a fast 20-minute demo using Power BI Desktop and Sublime Text, proving you can generate a self-contained date table without external sources. Code uses List.Dates, DateTime.LocalNow and Duration.Days to make a dynamic end date, converts the list to a table, adds a numeric date key (YYYYMMDD int) and dozens of columns: year, MMM, isYearToDate and months_ago/days_ago flags, plus workday math that handles weekends — the result loads and works in visuals.
AI-written summary · about
chapters (10)
- 0:00Introduction
- 1:34M code environment setup
- 3:00Why create date table
- 5:29Variables and date list
- 8:42List to table conversion
- 10:04Standard date columns
- 13:18Custom sorting columns
- 15:06Time intelligence columns
- 17:39Completed date table review
- 18:43Q&A
related talks
28mPower BI Pointers
50mTime Intelligence in Power BI
48mTime Intelligence in Power BI
01h 08mAdvanced Modelling and Calculation Using the Power BI Designer
45mMagnificent 7 - Simple Tricks to boost your Power BI Development
18mEmpowering Business Through Data
48mDon't be scared with Hybrid, they are only tables…
48mPower BI for Developers