'Pacing Period To Date Calculated Measure on SSAS cube - MDX
I want to produce a calculated member on our cube using MDX Expression that shows
- revenue booked at any point in time up for the current date of a given
Measure [Measures].[Rev]
Date Dimension [Date].[Year]
Contract Dimension [Contract].[Booking Date]
| Year-Month | Rev | Pacing Rev |
|---|---|---|
| 2021-01 | 10,000 | 10,000 |
| 2021-02 | 6,000 | 6,000 |
| 2021-03 | 12,000 | 12,000 |
| 2021-04 | 7,000 | 7,000 |
| 2021-05 | 9,000 | 4,500 |
| 2021-06 | 11,000 | 3,600 |
| 2021-07 | 13,000 | 1,000 |
Essentially I want to be able to determine how much Revenue was booked this time last year. if today = 17/05/2022 I want to see Pacing Rev for all contracts booked for 2021 from any point in time up until today 17/05/22.
What I mean by 'from any point in time. i.e. a contract could have been booked in 2018, for 2021 (hence why I think I'll need to use the [Contract].[Booking Date] some how
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|