How to Create a DATE TABLE in Power BI // DAX, From Source, Power Query // Step by Step Guide

In this video I cover the THREE different ways you can create a Date Table in Power BI; DAX, Power Query and from Source.

As usual, I use examples and step-by-step guide to not only show you can do these things but also WHY you want to be doing this in the first place, which I think is missed in a lot of other tutorials.

-
Get started with Power BI Desktop FREE

Generate a Date Table using Power Query (M Code)

-

Introduction: (0:00)
Why Create a Date Table: (0:36)
Disable Auto Date Time: (2:55)
Generate with DAX: (3:46)
Connect from Data Source: (5:34)
Create with Power Query: (6:06)
Outro: (7:08)

-

🚩 Support us to get perks such as demo files, early access and more!

MY FAVOURITE POWER BI BOOKS

MY GEAR

GET IN TOUCH

🌍 WHO IS SOLUTIONS ABROAD
Hi, my name is Fernan, the one-man band of Solutions Abroad. I work as a Data Scientist based in London, UK and have over 6 years of experience working in Business Intelligence. Solutions Abroad these days is dedicated to teaching the ins and outs of Power BI, through the power of YouTube.

If you want to learn more, I’ve conveniently created playlists to help you find the right topic for you.

🐎 First, watch this video about how a typical Power BI workflow looks like

🗺 Learn DAX to extend your Power BI calculations

📆 Stay up-to-date on all the features Power BI releases monthly

🧪 Get certified as a Microsoft Data Analyst Associate

💡 Learn Power BI Features to improve your dashboards

📊 WHAT IS POWER BI?
Power BI is a business analytics tool by Microsoft. It creates a working environment suited for normal users, meaning tasks such as data extraction, cleansing, analysis and storytelling; these are made easily-accessible to citizen-users, and extendable for technical users. At face value it provides visually-stunning, interactive dashboards, but it’s built on top of so much more.

🔻 Get started with Power BI Desktop for FREE

#PowerBI #DataAnalytics #BusinessIntelligence

[EyiBillion]

Brilliant! Love the Reza Rad MCode Date table creation acknowledgement. You Rock!

[ludekselepa]

I cant understand how isn't this have a million views by now? Its one of the best Guides there is on the web. And that includes How to Power BI channel. Fernan deserves better than this.

[samhall]

so helpful I will try both DAX and PQ methods

[Danny-Do-It]

I get this error CALENDARAUTO function can not find a base column of DateTime type in the model.? all rows are error

[bhainsley]

Thanks for this, Fernan! What is the advantage of the DAX approach vs the M code approach?

[cindypayet]

Hello, thank you very much for your videos. I cannot create relationships between my date table and my employee tables because I already have a relationship between my employee tables and a unique USER ID. How could I manage including a relationship with my date table additionally? Thanks a lot

[arunprakashk]

Fernan, I have been questioned by many of the interview how we can show the date of the sales amount. If there would be plenty sales occurred on the same date. Can you create a video for writing a Dax formula to bring the result?

[sherzodyuldoshev]

Hi, can you advise on how to handle date columns from 3 different table sources, where date rows are not same, but I want to visualize in a single line chart to see the trend over the years? Currently, I am struggling with making 1 universal date for 3 different tables during the year on monthly basis.

[bestofUS_]

is there a way to keep only last day data on the table but past 2 weeks line chart next to it on the same tab in power bi? This way i can see what is the ranking list as of today and how was the stats changing day by day on the chat for each ranked items past 2 weeks?

[tonykuiper]

Hi Fernan... I have a simple date table created from list and then turned into table. It has no complications. I have some data sets which I want to link to the date table, however every relationship only allows many to many. There is clearly something wrong in the datasets but I cannot see what. The date table has a unique date per row and the dataset also has a unique date in one of its columns. Any idea why the relationship will not be a one to many? Have I perhaps created a bad relationship somewhere else? I have tried deleting all relationships and starting again but the dates don't work as expected.

[petecardona]

Hi, can you help here? I tried the calendarauto, but it doesn't pickup my data's dates, it starts from 1899 and so on.