5 Replies Latest reply on Sep 30, 2016 1:49 PM by Shinichiro Murakami

    Using a parameter to filter fiscal date ranges

    Nick Pittman

      Hi. I'm trying to use a date parameter to select a specific week from which to calculate YTD, QTD, and MTD measures. The parameter ('As of date') is synonymous with a column in my data that contains last day of a fiscal week.

       

      So, its easy enough to set the upper bound of the date range (Fiscal Week End Date <= As of Date) but I'm struggling to find a way to set the lower bound for MTD, QTD and YTD- in other words, how far back to go. I can't simply use the month and year of the parameter since the calendar month/year may differ from the fiscal month/year.

       

      Any suggestions?

       

      Thanks,

      Nick