Things You Must Know When Using a Date Table in Power BI

Curious about the best ways to handle dates in Power BI? In this video, Manuel Quintana from Pragmatic Works explores why you need a dedicated date table, how Power BI automatically creates hidden date tables by default, and how to optimize your data model by disabling Auto Date/Time. Learn how to reduce model size, improve performance, and maintain full control of your time-based data with these essential tips. 👉 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/ 00:00 - Introduction 00:28 - Why Use a Dedicated Date Table 01:19 - How Auto Date/Time Works 02:55 - Exploring the PBIX Demo 06:50 - Checking Hidden Tables in DAX Studio 08:11 - Disabling Auto Date/Time 10:33 - Impact on Model Size 14:43 - When Auto Date/Time Is Still Useful 16:02 - Conclusion Let's connect: ✔️Discord: https://prag.works/yt-discord ✔️Facebook: https://prag.works/yt-fb ✔️Instagram: https://prag.works/yt-insta ✔️LinkedIn: https://prag.works/yt-li Pragmatic Works 7175 Hwy 17, Suite 2 Fleming Island, FL 32003 Phone: (904) 638-5743 Email: [email protected] #PragmaticWorks