If you want to analyse anything over time, there is likely no more important table to create for any Power BI model that a great date table.
I rarely, if ever, run any time analysis over date tables in fact tables. I always create a date table and then build a relationship over to the fact table (like a sales data table).
Why should you do this? Well, there are a few reasons, which I go into in this video.
The key, though, is learning how to create a really good date table, fast. You want to make sure that you have all the right code in place to do this over and over again.
A date table can be created in a few ways. In this example I use the ‘M’ code within the query editor. I personally think this is a really efficient way to do it, because you can make other small changes to the table within the query editor at the same time.
This video shows you how you can do just that, and how you can do it really quickly in all your models.