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
powerbi.microsoft.com/en-us/d...
Create a Date Dimension by Radacad.com
radacad.com/create-a-date-dim...
Generate a Date Table using Power Query (M Code)
www.dropbox.com/s/0tu8v844xtv...
-
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!
/ solutionsabroad
MY FAVOURITE POWER BI BOOKS
📕 The Definitive Guide to DAX - amzn.to/3ruYs2f
📗 DAX Patterns - amzn.to/3oVgOYs
MY GEAR
🎥 Canon 4000D DSLR Camera - amzn.to/3tCqDOw
💻 Cyberpower Wyvern PC - amzn.to/3q04QOw
🪑 Infamous Gaming Chair - amzn.to/3q3iUXw
💡 LED Studio Lighting - amzn.to/3q3ftQz
🎙 Lavalier Microphone - amzn.to/3jwKutG
📺 Monitor - amzn.to/2LuHhhO
GET IN TOUCH
📺 Website - www.solutionsabroad.co.uk
📧 Email me - [e-mail]
🤵 LinkedIn - / solutionsabroad
📘 Facebook - / solutionsabroad
📸 Instagram - / solutions_abroad
🐤 Twitter - / abroadsolutions
🤖 Reddit - / fernanespejo
🌍 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 CZcams.
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
• Power BI from START to...
🗺 Learn DAX to extend your Power BI calculations
• Power BI DAX Basics OLD
📆 Stay up-to-date on all the features Power BI releases monthly
• Power BI Monthly Featu...
🧪 Get certified as a Microsoft Data Analyst Associate
• Power BI DA 100 Prepar...
💡 Learn Power BI Features to improve your dashboards
• Power BI Feature Highl...
📊 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.microsoft.com/en-us/d...
#PowerBI #DataAnalytics #BusinessIntelligence

[@EyiBillion]

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

[@ludekselepa6621]

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.

[@samhall100]

so helpful I will try both DAX and PQ methods

[@ashokkumarpadmanabhan6483]

Awesome Video !!!

[@drontek5638]

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

[@saketsrivastava84]

Best video

[@tonykuiper9127]

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.

[@bakls1009]

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?

[@arunprakashk8384]

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?

[@sherzodyuldoshev3461]

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.

[@petecardona8203]

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.

[@bhainsley]

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

[@SolutionsAbroad]

Hi Billson, its a minor difference,
M Query - Calendar is "pre-loaded" and is basically another table on your data model.
DAX - Calendar table is calculated on the fly, and so it doesn't take any space in your model
Hope that helps!

[@markgros7934]

Great explanation. Been searching for this for awhile. As a new user of power bi, this solves so many issues I’ve had on building my reports. Thank you!

[@cindypayet281]

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

[@SolutionsAbroad]

Hey Cindy thanks for watching my videos! is your unique user id creating a recursive issue with your date table? You can look at using TREATAS to create a virtual relationship: czcams.com/video/YALX5cDMSfc/video.html