Programmatic Ways of Creating a Date Dimension (SQL / DAX / M)

There’s a great deal of overlap among these techniques. I list all the ones I’ve stumbled upon for completeness. The entries are in no particular order.

But first, why? The answer from Reza Rad at RADACAD

T-SQL Methods

DAX Methods

Power Query Methods

SSAS and Time

Other Calendar / Date / Time References