Could you please tell me How the MDX query should be to find Current Snapshot value Previous Snapshot Value. I have a fact table which will be populated with all the data pertianing to all the months for that project. Every month a snapshot will be generated and will be in Fact table. Now when i show the data in Report by default i should show Current Snapshot's data and for displaying trends in Scorecrd i need to take Previous Snapshot Data.

I have Fact Table, Project and Period dimensions for this requirement.

Please help me on this.