Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Nuno
Starting Member
21 Posts |
 Posted - 2005-09-14 : 06:39:30
|
| Hi Gurus,After Vancances...I'm back to ask you something eassy for you....I will need to calculate a measure that give me the last December?Thanks in advance for your help.Nuno |
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2005-09-14 : 08:21:58
|
| The last December what? Nuno, we can't understand your question.Mike"oh, that monkey is going to pay" |
 |
|
|
Nuno
Starting Member
21 Posts |
Posted - 2005-09-14 : 10:26:40
|
| Hi,Thanks for your post.For instance....If I want a homologous Period I have:iif ( (ParallelPeriod([TIME].[PERIOD], 12), [Measures].[BALANCE])=null, Null, (([TIME].CurrentMember, [Measures].[BALANCE])- (ParallelPeriod([TIME].[PERIOD], 12), [Measures].[BALANCE])))I'm in September 2005How can I build de December 2004, consider my measure: [BALANCE]Nuno |
|
|
|
|
|
|
Calculated Measure