Last n Periods

The Last functions return a list of the last n given time periods, prior to the given time period. For example, you may create a custom list of the last 6 months. If you select October 2009 from the slicer, a list of all months, from April 2009, up to and including October 2009, will be returned.

The Last functions return:

If you want the option to inject a date into the query at runtime, and see the Last n time periods prior to the given date, be sure to select "Parameterize all Calculations". This will produce a parameter, which is automatically added to the query when you select one of the elements generated by the Time Intelligence wizard. If the Last calculations are not parameterized, then the Last n time periods prior to the most recent date in the model will be returned.