yes that can be done. Please attach a sample workbook and your requirement.
See the attached
the formula below will set the date range - year to date for each year based on the parameter
And will return this
I just put in a table calc for YOY to show how it works
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
this year last year.twbx 1.2 MB
This was definitely helpful. Unfortunately, this does not take into account my calendar parameters or my other filtered criteria (which wasn't in the initial scope). Do you know if there is an easy solution to adjusting this to a specific fiscal year cycle? I've already adjusted my original date source to my FY start, thought that may compensate, but it doesn't seem like it.