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