Forum Discussion
Custom Fiscal Calendar Table with Different Days in Months
Community Champion
this guy does a lot of youtube vidoes on the topic, can't point out which one exactly, but this might be helpful
Thanks for the help, this works perfectly for YTD running totals.
Still running into roadblocks on the prior year totals.
jpt1228Responsive Resident
This 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.