Expandable Excel calendar table including US holidays and workdays.
Time intelligence Calendar table in Excel used for custom time intelligence calculations in DAX. It includes text labels, US holidays, numeric calendar references, and unique sequence numbers for calculating custom time intelligence at the year, quarter, month, and week granularity.
Calendar Table Includes:
- “Name Columns” that provide for reporting labels such as Day Name, Month Names, and Quarter Name labels.
2. “Number Columns” that provide for specific Month (1-12), Week in year, Day in year (1-365), Day in week (1-7), and Quarter numbers (1-4).
3. “Sequence Columns” that provide for a continuous number sequence that extends over the entire table. All numbers in these columns are continuous and help when writing custom time intelligence functions that trace period over period changes.
4. Leap years with February 29, are folded into the prior day (February 28) when accounting for Week
Thanks for visiting Story BI!

Leave a Reply