![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/34534dae9cf60992d58f0932243f7b26321163bb/26043.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/3605bc1e91cdb5184efe892ae8f33fc546844313/26035.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/39590db0ae6aa6423de474b3e3799ce67181bec1/26037.png)
Stairway to MDX - Level 11: MDX Time/Date Series Functions: PeriodsToDate() and Derivative Shortcut Functions – SQLServerCentral
![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
![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
![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
![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/legacy/54fcd8ff24c3283bafdad43917d3990edbbeafc6/26036.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)