Unanswered: MDX Help: How to select last changed value of a measure
I am hopelessly lost on a MDX-Statement. We are trying to select the last changed value of a measure within the last 30 days and compare this to the current measure value to see wether this has increased, decreased or not changed at all.
We have basically 2 Dimensions (Timeline and Opportunity) and 1 Fact (Revenue). As already described we now want to evaluated, whether revenue has changed within the last 30 days. The result will be displayed in a SSRS-Report (don't have a problem here).
"All" I need to select via MDX, would be the last changed value and the current value. I tried to use the KPI function, but unfortunatly to no avail.
Could anyone give as a hint how to do such a select in MDX?
I want to take a look at the data of the last e.g. 30 days and get the information if the revenue per sales-opportunity has changed or not, and if so if the change was positive or negative. The ideal result based on above data would look something like this: