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.
***** Learning Power BI? *****
All Enterprise DNA TV Resources
FREE COURSE – Ultimate Beginners Guide To Power BI
FREE COURSE – Ultimate Beginners Guide To DAX
FREE – 60 Page DAX Reference Guide Download
FREE – Power BI Resources
Enterprise DNA Membership
Enterprise DNA Online