Date Tables in Power BI – How To Create A Comprehensive One Really Fast

2 comments

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 – Power BI Resources

2 comments on “Date Tables in Power BI – How To Create A Comprehensive One Really Fast”

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s