tcc-sejohnson/awesome-date-dimension: The best date dimension build/refresh script you’ve ever seen! Written in T-SQL.

This template also provides tables and refresh scripts for a DimFiscalMonth and a DimCalendarMonth. These roll up details from DimDate into a dimension you can use to join pre-aggregated tables together. This can be useful when trying to join fact tables that are at different date granularities or when trying to create a pre-aggregated model in Power BI.