Do you think your end users would like to just be able to toggle a True/False option to view the previous year's worth of sales information? Huh? Do Ya? You bet they would!!!
- Open your tabular SSAS project
- Add a new calculated column to your Calendar dimension and name it RollingTwelveMonths
- Add the following (or similiar depending on your column names) DAX calculation to the column
((NOW() - DimCalendarPeriod[FullDateAlternateKey]) * 1) < 365,
- Make sure you make the new column visible through your perspectives or default view, then deploy and process your project.
Now when your end users view a pivot table report they'll have the following option available: