NRF Retail Calendar

Has anyone implemented YTD, MTD and WTD calculations using the 4-5-4 Retail Calendar? See picture for the first quarter of 2019 dates and the corresponding dates for 2020. The biggest issue I see (maybe I am wrong) is the first date of the year changes every year.

So how do you calcualate YTD =

Base Measure: Total Sales = sum(Sales)

Sales YTD =
Calculate (Total Sales , ??? )

Sales WTD =
Calculate(Total Sales, ???)

Sam covers this in the Time-Intelligence Mini-Series module. You cannot use the built in time intelligence functions and need to have a detailed Calendar table and then you can explicitly write out the function, but the the module covers all of that.

Sounds good I will check it out tomorrow.