Forum Discussion
Custom Fiscal Calendar Table with Different Days in Months
Thanks for the help, this works perfectly for YTD running totals.
Still running into roadblocks on the prior year totals.
Responsive ResidentThis is a late reply, but found your post researching a similar issue. I have been able to solve the custom date calendar which is most of the problem. I too have 13 - 4 week periods consisting of 28 days per fiscal period. Once you build the fiscal year, fiscal period, then I believe you can use same time last year, fiscal period to date etc. I have created a couple custom columns in my date table that will filter visuals on current fiscal period true/false (filter visual on true to view current fisc period) and current fiscal year which will give you a fiscal YTD number if filtered on true for current fiscal period.