Getting Relative Month/Year Columns Into a 445 Calendar Table

Relative Month and Year columns in calendar tables are indispensable. They let you create simple, easy to read time intelligence measures that don’t require recoding at the end of each year/month to redefine what “this year/month” is. With them you can write real simple measures like:

Total Sales Current Year = 
    [Total Sales],
    DimCalendar[Relative Year] = 0 //AKA This Year


Total Sales Last Month = 
    [Total Sales],
    DimCalendar[Relative Month] = -1 //AKA Last Month

But drop into the word of 4-4-5 calendar tables and they become much harder to create. In this video we’re going to show you an easy way to generate them using a self join.

Happy Reporting!

Share This:

Stay up to date with the latest customer data news, expert guidance, and resources.

More Resources

Your Data, Analytics & AI Partner

Industry leaders choose SkyPoint as their comprehensive and compliant Modern Data Stack Platform. A Certified Microsoft Solutions Partner, SkyPoint Cloud turns siloed data into connected experiences.