hello,

i could need some help in developing a measure which displays the difference of two values from the selected years.

An example:

Show the difference of the sales amount from 2013 and 2015.

Since i am not really into mdx or calculated members, i hope i provided all informations you need.

thank you very much in advance and kind regards

dj

I am not sure how you using it but if this can give you some idea how to go ahead. this may not be a complete answer.

With
set as SelectedYears as extract(Axis(0),[Date].[calendar])
Member diffPercentage as
[measures.[salesamount]/ (SelectedYears.Item(0).Hierarcy.prevMember,[measures.[salesamount]),format_string="0.00%;-0.00%"

Hi jDotmDot,

In this scenario, you just need to create a calculated measure to compare the fact data sliced by the currentmember and prevmember. Please refer to query below:

with member [x] as
aggregate([Date].[Calendar].currentmember,[Measures].[Internet Sales Amount])-
aggregate([Date].[Calendar].prevmember,[Measures].[Internet Sales Amount])
select [Measures].[x] on 0,
[Date].[Calendar].[Calendar Year].members on 1
from
[Adventure Works]

Regards,