![SQL Server Analysis Services MDX: Sum of Last N Years, Quarters, Months, Periods. - Insight Extractor - Blog SQL Server Analysis Services MDX: Sum of Last N Years, Quarters, Months, Periods. - Insight Extractor - Blog](https://i0.wp.com/insightextractor.com/wp-content/uploads/2014/06/mdx-current-year-vs-previous-year-same-fiscal-period.png?resize=350%2C200&ssl=1)
SQL Server Analysis Services MDX: Sum of Last N Years, Quarters, Months, Periods. - Insight Extractor - Blog
![PowerPivot time intelligent functions revisited: why use ALL() and how to work around it - Kasper On BI PowerPivot time intelligent functions revisited: why use ALL() and how to work around it - Kasper On BI](https://i0.wp.com/www.kasperonbi.com/wp-content/uploads/2010/03/woall.png?resize=304%2C331)
PowerPivot time intelligent functions revisited: why use ALL() and how to work around it - Kasper On BI
![Stairway to MDX - Level 11: MDX Time/Date Series Functions: PeriodsToDate() and Derivative Shortcut Functions – SQLServerCentral Stairway to MDX - Level 11: MDX Time/Date Series Functions: PeriodsToDate() and Derivative Shortcut Functions – SQLServerCentral](https://www.sqlservercentral.com/wp-content/uploads/legacy/7921458afc96a8da40140cf64a746e70a2c27f61/26034.png)
Stairway to MDX - Level 11: MDX Time/Date Series Functions: PeriodsToDate() and Derivative Shortcut Functions – SQLServerCentral
![SQL Server Analysis Services MDX: Sum of Last N Years, Quarters, Months, Periods. - Insight Extractor - Blog SQL Server Analysis Services MDX: Sum of Last N Years, Quarters, Months, Periods. - Insight Extractor - Blog](https://i0.wp.com/insightextractor.com/wp-content/uploads/2014/04/create-a-calculated-measure-in-mdx-to-compute-last-3-years-sales-amount.png?fit=727%2C236&ssl=1)
SQL Server Analysis Services MDX: Sum of Last N Years, Quarters, Months, Periods. - Insight Extractor - Blog
![Stairway to MDX - Level 11: MDX Time/Date Series Functions: PeriodsToDate() and Derivative Shortcut Functions – SQLServerCentral Stairway to MDX - Level 11: MDX Time/Date Series Functions: PeriodsToDate() and Derivative Shortcut Functions – SQLServerCentral](https://www.sqlservercentral.com/wp-content/uploads/2011/02/tile-2.png)
Stairway to MDX - Level 11: MDX Time/Date Series Functions: PeriodsToDate() and Derivative Shortcut Functions – SQLServerCentral
![Stairway to MDX - Level 11: MDX Time/Date Series Functions: PeriodsToDate() and Derivative Shortcut Functions – SQLServerCentral Stairway to MDX - Level 11: MDX Time/Date Series Functions: PeriodsToDate() and Derivative Shortcut Functions – SQLServerCentral](https://www.sqlservercentral.com/wp-content/uploads/legacy/21924da538081294aea68c59199674b843fd1162/26038.png)
Stairway to MDX - Level 11: MDX Time/Date Series Functions: PeriodsToDate() and Derivative Shortcut Functions – SQLServerCentral
![Stairway to MDX - Level 11: MDX Time/Date Series Functions: PeriodsToDate() and Derivative Shortcut Functions – SQLServerCentral Stairway to MDX - Level 11: MDX Time/Date Series Functions: PeriodsToDate() and Derivative Shortcut Functions – SQLServerCentral](https://www.sqlservercentral.com/wp-content/uploads/legacy/51a2fd7db2d44cc6f34a0ccef7a213a6559e6131/26042.png)
Stairway to MDX - Level 11: MDX Time/Date Series Functions: PeriodsToDate() and Derivative Shortcut Functions – SQLServerCentral
![Stairway to MDX - Level 11: MDX Time/Date Series Functions: PeriodsToDate() and Derivative Shortcut Functions – SQLServerCentral Stairway to MDX - Level 11: MDX Time/Date Series Functions: PeriodsToDate() and Derivative Shortcut Functions – SQLServerCentral](https://www.sqlservercentral.com/wp-content/uploads/legacy/52a32efd3aca5e9ca1e9d22be80bab73c2ba03e0/26044.png)
Stairway to MDX - Level 11: MDX Time/Date Series Functions: PeriodsToDate() and Derivative Shortcut Functions – SQLServerCentral
![Stairway to MDX - Level 11: MDX Time/Date Series Functions: PeriodsToDate() and Derivative Shortcut Functions – SQLServerCentral Stairway to MDX - Level 11: MDX Time/Date Series Functions: PeriodsToDate() and Derivative Shortcut Functions – SQLServerCentral](https://www.sqlservercentral.com/wp-content/uploads/legacy/b1556cf2bcf7cd78e7f1101eed2fd3d097f3c312/26040.png)
Stairway to MDX - Level 11: MDX Time/Date Series Functions: PeriodsToDate() and Derivative Shortcut Functions – SQLServerCentral
![Stairway to MDX - Level 11: MDX Time/Date Series Functions: PeriodsToDate() and Derivative Shortcut Functions – SQLServerCentral Stairway to MDX - Level 11: MDX Time/Date Series Functions: PeriodsToDate() and Derivative Shortcut Functions – SQLServerCentral](https://www.sqlservercentral.com/wp-content/uploads/legacy/0c8af741bc4ad7f14f84e773309342f279e22cf1/26041.png)
Stairway to MDX - Level 11: MDX Time/Date Series Functions: PeriodsToDate() and Derivative Shortcut Functions – SQLServerCentral
![Stairway to MDX - Level 11: MDX Time/Date Series Functions: PeriodsToDate() and Derivative Shortcut Functions – SQLServerCentral Stairway to MDX - Level 11: MDX Time/Date Series Functions: PeriodsToDate() and Derivative Shortcut Functions – SQLServerCentral](https://www.sqlservercentral.com/wp-content/uploads/legacy/a7a2df19def70b588d30ae8565bcad19a5fdb68e/26039.png)
Stairway to MDX - Level 11: MDX Time/Date Series Functions: PeriodsToDate() and Derivative Shortcut Functions – SQLServerCentral
![Stairway to MDX - Level 11: MDX Time/Date Series Functions: PeriodsToDate() and Derivative Shortcut Functions – SQLServerCentral Stairway to MDX - Level 11: MDX Time/Date Series Functions: PeriodsToDate() and Derivative Shortcut Functions – SQLServerCentral](https://www.sqlservercentral.com/wp-content/uploads/legacy/700298d9e3404ab3410d2cb50e8e1d25f6c2078e/26046.png)