Building Your First Calendar Table in Power BI!

Get a complete step-by-step guide to building out a dedicated calendar table and independent date hierarchy (using DAX) in Power BI. Tune in to learn more!
RELATED CONTENT 🔗
Date Hierarchy Types - bit.ly/3PrCsBd
DAX Vs. Power Query Date Table - bit.ly/3Omj6wF
Power Query Dynamic Date Range - bit.ly/3O6tXuu
BECOME A CHANNEL MEMBER 🎉
-- / @havensconsulting
LET'S CONNECT! 🧑🏽‍🤝‍🧑🏽 🌟
-- / havensbi
-- / reidhavens
-- / havensconsulting
-- / havensconsulting
VIDEO CHAPTERS 🎥
0:00 - Start of Video
0:36 - Content Intro
3:20 - Using the CALENDAR Function
5:20 - Adding Additional Columns
8:49 - Creating Date Hierarchy
HAVENS CONSULTING PAGES 📄
Home Page - www.havensconsulting.net
Blog -- www.havensconsulting.net/blog-...
Blog Files -- www.havensconsulting.net/blog-...
Files & Templates -- www.havensconsulting.net/files...
Consulting Services -- www.havensconsulting.net/consu...
Online Courses -- www.havensconsulting.net/onli...
Contact & Support - www.havensconsulting.net/conta...
EMAIL US AT 📧
[e-mail]
#PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #excel #powerapps #datavisualization #dashboard #bi #analytics #powerquery #dax #timeintelligence #date #calendar

[@jaytricegarrett880]

This is SOO Awesome! It helped me create a custom calendar table for my report that I have been struggling with for months! Thank you so mush for sharing this!

[@HavensConsulting]

Glad it helped!

[@dreaming_freespirit]

Very clear instruction and a great method of using independent hierarchy. Thanks for sharing.

[@HavensConsulting]

Sure thing!

[@datadragyn]

This is awesome and so timely 😊 well done as always 😊

[@HavensConsulting]

Thank you!

[@tacijjola]

Oh my gosh! Perfecto! Thank you 🙌

[@Mazafucka1000]

Thank you a lot!

[@HavensConsulting]

You're welcome!

[@pratik2998]

Can I join the calendar table with 2 other tables in my model? I wanted to filter date by calendar table's date and affect/slice other 2 tables' values as well

[@HavensConsulting]

Absolutely! As long as each table has a date datatype column you can join it to multiple fact-type tables :)

[@pratik2998]

@@HavensConsulting thanks for confirming.