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 , ??? )