Dynamic Date Table Using the Power Query Editor

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 On-Demand Learning! -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - - Next step on your journey: 👉 On-Demand Learning - Start With The FREE Community Plan: https://prag.works/odl-trial-yt 🔗Pragmatic Works On-Demand Learning Packages: https://pragmaticworks.com/pricing/ 🔗Pragmatic Works Boot Camps: https://pragmaticworks.com/boot-camps/ 🔗Pragmatic Works Hackathons: https://pragmaticworks.com/private-training/hackathons/ 🔗Pragmatic Works Virtual Mentoring: https://pragmaticworks.com/virtual-mentoring/ 🔗Pragmatic Works Enterprise Private Training: https://pragmaticworks.com/private-training/customized-enterprise-training/ 🔗Pragmatic Works Blog: http://blog.pragmaticworks.com/ Let's connect: ✔️Twitter: https://twitter.com/PragmaticWorks ✔️Facebook: https://www.facebook.com/pragmaticworks/ ✔️Instagram: https://www.instagram.com/pragmatic.works ✔️LinkedIn: https://www.linkedin.com/company/pragmaticworks ✔️YouTube: https://www.youtube.com/pragmaticworks Pragmatic Works 7175 Hwy 17, Suite 2 Fleming Island, FL 32003 Phone: (904) 638-5743 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