I use “columns” and “fields” interchangeably in this post.
There are many posts out there showing how to create a date table and I believe this is because it’s a common problem that almost everyone encounters when first making a data model in Power BI, Excel, or Analysis Services.
By “common problem” I mean that it’s the one dimension that almost every data model shares, and fitting it to your data model can sometimes be a bit tricky.
You can create date tables in SQL, DAX, M, and many other programming languages.
In this post I want to show you how you can make a date table in Power Query’s M language, as well as explain what fields I think are important and how you can create them.