The BEST (free) Date Table Template - and how to use it!

Date tables, also known as calendar tables, are VERY useful in Power BI! Here’s a template you can use to get started. Date tables are used to measure by fiscal year, fiscal quarter, week, weekend, holiday - virtually any date-related period. 🛠️ RESOURCES - Brian Grant’s date table template: https://skypoint.ai/blog/calendarfornia-dreamin-m-calendar-script/ (thanks for your suggestions, folks, this one is still my favorite! 😄) - Another template a couple people mentioned in the comments, by Melissa De Korte: https://forum.enterprisedna.co/t/time-intelligence-series-by-brianj-and-melissa/7745 (uses a function invocation) - A third template option from Martyn Booth: https://www.notjustaprettydashboard.com/the-ultimate-power-bi-date-table-bonus-date-periods-table/ (this one is "hefty"...) - Relative date column calculation for slicer we use in the video for the: https://christine-payton.com/date-tables-in-power-bi/ ⏲️ TIMESTAMPS 0:00 Intro 0:53 Get the template 2:13 Configure the date table 3:34 Relate the date table 4:59 Turn off auto-date time 5:48 Sort by another column 6:36 Multiple date relationships 7:25 Use in visuals 9:17 Field parameters for dynamic date axis buttons 12:33 Relative date filtering (e.g. “last fiscal year”) RELATED VIDEOS - Need to add holidays? Brian Julius has a video here: https://www.youtube.com/watch?v=v9s0PPLU0n8 CONNECT WITH ME 📣 Get new videos via email! - https://bi-ome.kit.com/youtube 📝 Blog - https://christine-payton.com/ 🔗 LinkedIn - https://www.linkedin.com/in/christinehpayton/ 💬 Questions? Drop them in the comments! Your question could help others too. #powerbi #datamodeling