In this tutorial video, we'll learn how to create a dynamic date table in Microsoft Power BI using the Power Query Editor. A date table is a fundamental component of many data models and can help us analyze and visualize data by date more efficiently.

If you enjoy this video and are interested in formal training on Microsoft Teams, Power BI, Power Apps, Azure, or other Microsoft products you can visit https://prag.works/ANGELICA40 for 40% off OnDemand Learning!

Next step on your journey:

OnDemand Learning Start With The FREE Community Plan: https://prag.works/odltrialyt

Pragmatic Works OnDemand Learning Packages: https://pragmaticworks.com/pricing/
Pragmatic Works Boot Camps: https://pragmaticworks.com/bootcamps/
Pragmatic Works Hackathons: https://pragmaticworks.com/privatetr...
Pragmatic Works Virtual Mentoring: https://pragmaticworks.com/virtualme...
Pragmatic Works Enterprise Private Training: https://pragmaticworks.com/privatetr...
Pragmatic Works Blog: http://blog.pragmaticworks.com/

Let's connect:

✔Twitter:   / pragmaticworks  
✔Facebook:   / pragmaticworks  
✔Instagram:   / pragmatic.works  
✔LinkedIn:   / pragmaticworks  
✔YouTube:    / pragmaticworks  


Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: (904) 6385743
Email: [email protected]
#pragmaticworks

00:00 Purpose of a Date Table
02:22 Benefits of a Separate Date Table
03:29 Creating a Blank Query for Date Table
04:39 Generating a 3 Years Prior Column
06:47 Adding Start Date Column
08:21 Creating a List for Full Date Column